Select..Into Statement Options

[rocketD]

Hi All,
I'm following the suggestion in this thread
http://groups.google.com/group/micr...atically+output+to+text+file#c663ceb2843f4e71
to output a delimited table. It works just fine, but it's not quite
what I need.

Is there a way to customize the output table so that the delimiter is
a tab instead of a comma, and that quotes aren't included around the
text vs. numbers? I googled my question but didn't get anything.

Thanks,
Dara

 

[rocketD]

I realized I should post the code in case you don't want to follow the
thread...
SELECT.....
INTO [Text; HDR=yes; Database=O:\Geologists\].test2.txt
......;

 

[John W. Vinson]

Hi All,
I'm following the suggestion in this thread
http://groups.google.com/group/micr...atically+output+to+text+file#c663ceb2843f4e71
to output a delimited table. It works just fine, but it's not quite
what I need.

Is there a way to customize the output table so that the delimiter is
a tab instead of a comma, and that quotes aren't included around the
text vs. numbers? I googled my question but didn't get anything.

Thanks,
Dara

I'd suggest using VBA code using the TransferText method instead. That lets
you specify delimiters, quotes or not, fixed length, whatever - more flexible
than the SELECT INTO query.

 

[aaron.kempf]

you should just learn a real ETL tool, like SQL Server or SSIS

these tools are easy to automate, and they have a future.

Jet has been obsolete for a decade

Sorry

-Aaron

 

[rocketD]

you should just learn a real ETL tool, like SQL Server or SSIS

these tools are easy to automate, and they have a future.

Jet has been obsolete for a decade

Sorry

-Aaron





- Show quoted text -

Oh my gosh, Aaron, that's such helpful advice. I'll just go hook up
to a computer all Matrix-style and input the knowledge in a couple
hours, eh?

 

[rocketD]

I'd suggest using VBA code using the TransferText method instead. That lets
you specify delimiters, quotes or not, fixed length, whatever - more flexible
than the SELECT INTO query.

John, I looked into TransferText and got it set up exactly as I
needed. I had to make my own export schema, but that was simple too.

Thanks for pointing me in the right direction!

 

[aaron.kempf]

it's not so hard.. take a class-- pick up a book.

just use a real-mans tool because Jet is for ****ing pussies

-Aaron

 

[carol]

you should just learn a real ETL tool, like SQL Server or SSIS

these tools are easy to automate, and they have a future.

Jet has been obsolete for a decade

Sorry

-Aaron





- Show quoted text -

Oh my gosh, Aaron, that's such helpful advice. I'll just go hook up
to a computer all Matrix-style and input the knowledge in a couple
hours, eh?