CVS format 2

[peljo]

I was asked to send a query from my Access database to my logistics centre but they require it CVS format and i do not know how to do it.The CVS format is not known to me .My query in its simplified form is :
SELECT orders.orderid, orders.orderdate
FROM orders;
Could you advise me from where shall i begin ?

 

[KenReay]

Hi

It is CSV format, it stands for (c)omma (s)eperated (v)ariable. It means the data is in fhe form aa,bbb,ccc,ddd.

You can do this by setting the appropriate parameter in the docmd object, see

http://www.blueclaw-db.com/download/transfertext_outputto_examples.htm

for examples

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[peljo]

Thank you for your help. Folowing your advice i have suceeded in creating the command, and the file does appear in MyDocuments, but it is an excel file. Have i done something wrong? Because the ending was "QryDocs.csv" and i get an excel file ?


DoCmd.TransferText acExportDelim, "qryDocExportSpecification", "QryDocs", "QryDocs.csv

 

[lespaul]

you may have *.csv files set up to be opened by excel by default....try right clicking on the file, select 'Open With' and choose notepad. You should see the information as a comma separate list.

 

[peljo]

Thank you !!