I've got a problem when exporting. When I tried to export a table to a
text
file including the field name it always comes with a comma delimiter and
the
field name seems to jam in one line.
How can I delete this comma ? and snap the field name to its field grid
(Like excel form)? thanks
If I understand you correctly, you are using Access to export a delimited
text file, but you don't want it to have commas between the column values as
a delimiter.
Does your import file look like this: ?
"ColHead1","ColHead2","ColHead3"
"Value1","Value2","Value3"
And you want it to look like this: ?
ColHead1 ColHead2 ColHead3
Value1 Value2 Value3
If so, run the Import / Export Wizard in Access to export your file, and
look for a button that says, [Specs...]. You can click that button, and
save the details of your export format to an "Import / Export Specification"
where you can tell it to use something else instead of commas for the Field
Delimiter. For example, If you intend to export your file as "tab
delimited", you would specify {Tab} as the field delimiter in the Access
IMEX Wizard instead of {comma}. Then you can save that information for
later use in other import / export batches.
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Veritas e aequitas; in nominae Patri, et Fili, et Spiritus Sancti."
-- The Boondock Saints