Comma Delimited

[aMack]

I am a newbie:

How do I import Comma Delimited files into Access?

How do I create Comma Delimited files from Access?

Thanks

 

[Ken Sheridan]

For the former select File | Get External Data | Import from the main
database menu bar, browse to the text file and then follow the prompts in the
wizard.

For the latter select the table or query in the database window, then select
File | Export from the main database menu bar, browse to the folder you want
to create the file in, enter a file name and then follow the prompts in the
wizard.

Ken Sheridan
Stafford, England

 

[Douglas J. Steele]

To import, go to File | Get External Data | Import... and set "Files of
type" (bottom left-hand corner) to "Text Files (*.txt;*.csv;*.tab;*.asc)"
(Note that your file extension must be one of those 4 choices, or it will
not import). A wizard will walk you through the import. Another alternative
is to use the TransferText method (or the TransferText action if you don't
like using VBA).

To export, use the OutputTo method (or action)

 

[aMack]

Ken:

Thanks - any way to automate the export process?