transfertext changes field name from # to .

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import fields from .csv with variable column structure 4
TransferText File Name 2
TransferText "Unparsable Record" error 2
TransferText Date/Time 2
Importing what file name? 3
Transfertext via Macro 5
TransferText 2
Exporting to text with "#" in a field name 3

Top