exporting to csv

[Glenn]

I have a table that I need to be able to export to a txt (CSV) file, which
is no problem, except for the way I need the header row.

I am going to use the exported file to do an import for an automated calling
system.

The way the calling system import is setup is to look for specific names of
fields for the entire database in the first row.

My problem is that the names of the fields is needs are different from the
ones in my database, and I can't change the names of my fields due to other
things they are linked to, as well as the fact that on the import file I
need to use the field "GROUP" several times, and access will only let you
have the field name once.

Basically, here's what I'm trying to do:

My Table in Access:

FIRSTNAME LASTNAME PHONE GROUP1
GROUP2 GROUP3
John Doe 555-555-1212
English Spanish Russian


I need the CSV export file to look like this:

"FIRSTNAME","LASTNAME","HOMEPHONE","GROUP","GROUP","GROUP"
"John","Doe","555-555-1212","English","Spanish","Russian"


You'll see from my original database the fields "phone", "group1", "group2",
and "group3" were changed to "homephone","group","group","group" in the
export file.

Is it possible to set this up? If so, how?

Thanks in advance!

 

[Guest]

Hi Glenn -
Have you tried creating a report and exporting it as the CSV?

 

[Glenn]

No, I did not know that was possible. I'll give it a try.

Thank you.

 

[Glenn]

I tried it, and it works a little better, but doesn't give me what I need.

There was no choice of CSV, so I picked TXT.

The first problem - there are no commas, when I open the txt file, it looks
like it is separated by tabs.

The other problem is that it separates the pages as it would if I were
printed....for instance a quarter of the way down you see today's date and
the field names again.

Any suggestions for fixing this?