G
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!
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!