export file

[mikeba1]

I need to create an export file with semicolon as the delimiter.

Any ideas

Thnks

 

[PHV]

Have a look at the DoCmd.TransferText acExportDelim method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mikeba1]

I already use the following

DoCmd.TransferText acExportDelim, , "qryacctsinterfacecsv", fn4

I see there is an entry for an export spec, but how do I create one.

I am using ver 2003

Thanks

 

[lameid]

In Access 2003 when you manually import or export a text file under the advanced button in the wizard you can save a specification. Tip, copy the name of the specification before saving it otherwise you might have to return to the wizard to remember it...

 

[dhookom]

If you forget the name, you should be able to find it by creating a query with this SQL

SELECT MSysIMEXSpecs.SpecName
FROM MSysIMEXSpecs;

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

Thanks guys

 

[mikeba1]

I have created an export specification with semi colons as the delimiter.
If the output file has the csv extension, it goes out as an excel csv,with commas as the delimiter.
If it goes out as .txt the file is listed correctly.
Does the csv extension ignore the export spec??

 

[dhookom]

I'm not sure what difference the extension would make. You could use the txt extension and then rename the file if you can't get the semi colons to stick with the csv.

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

Thanks Duane

This is where my knowledge of excel lets me down.

When I export my semi colon delimited file as .txt, it opens in notepad...
When I export it as .CSV, it opens as an excel CSV file in a spreadsheet, and shows the data delimited with a comma. However if I copy the contents of the spreadsheet to notepad, it shows the data delimited with a semi colon.

Curious ??

 

[dhookom]

If exporting your data to the txt file does what you want, isn't your work done?

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

I have to discuss this with the recipient of the file.


Thanks for your help