Export to CSV file

G

Guest

I need to create a CSV file with different record typess but each record
totals 300 bytes. I know how to export tables and queries but so far I've
only used single tables or queries. Can anyone help please? This is like a
redefine statement in COBOL for those who know it.
 
N

Nikos Yannacopoulos

AFAIK you cannot export multiple objects in one .CSV automatically. One
way around it is to create your file line by line in VBA code, by
opening each object in turn as a recordset, and looping through each
record and writing it to the text file.

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Wizard to csv 2
Export part of table to .csv file 1
Date format on exporting query to csv file from access 2007 3
Export Table as a csv file 1
Delimited Export Specification - independent of table 3
Export to Zip 1
Export 3 queries into 1 text file 2
Export more rows to a tab delimited file 1

Top