Export to CSV file

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top