transfertext changes field name from # to .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using transfertext (both as macro and in VBA) to csv, the program
automatically changes a field called "File#" to "File.". Anybody know why
and most importantly how to turn this reformat off? Thanks.
 
The # is a character that has special meaning in Access. It can't be used in
a field name unless it is enclosed in brackets, but really should not be used
anyway.
you can use an Import Fie Specification to specifiy field names when
importing.
Start an import "by hand", that is File, Get External Data, Import. Then
when you get the import wizard click on Advanced. In this dialog you can
specifiy field names and data types. Save the specifications you have set up
with a name. You can then use this name in the TranferText to define the
field names.
 
Back
Top