Exporting from Access to CSV

[ftpdoo]

I have a table in MS Access which i imported from a CSV:


Requested Action Code,17,17
Requested Action Code,18,18
Requested Action Code,19,19
Requested Action Code,20,20
Requested Action Code,21,21
Meter Period Number,01,01
Meter Period Number,02,02
Meter Period Number,03,03
Meter Period Number,04,04
Meter Period Number,05,05
Meter Period Number,06,06
Actual/Estimated Indicator,A,A
Actual/Estimated Indicator,C,C
Actual/Estimated Indicator,E,E


The question is this - is it possible to break each of these into a new CSV file and save it to my hard disk?

ie:

Requested Action Code.csv

17,17
18,18
19,19
20,20
21,21

Meter Period Number.csv

01,01
02,02
03,03
04,04
05,05
06,06

Thanks in advanced for any help / ideas of how to go about this..

Jonny

 

[PHV]

Once you have created the queries giving the expected resultsets play with the DoCmd.TransferText method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ftpdoo]

would it be possible for me to write a module in access to do this?

I have a table called results.. How do i reference this table from the module to start doing things to it?

Thanks
Jonny