TransferText Method question

G

Guest

I am using the TransferText method to import a text field into a table. The
default delimiter appears to be "comma" delimited fields. This is a problem
because some of the text fields occassionally have "commas" in them and this
messes up the import. Is there anyway to change the delimiter to a semi-colon
or some other character? Thanks for any assistance.
 
J

John Nurick

Hi Steve,

Import the data once manually, using File|Get External Data. Make the
necessary settings in the text import wizard, and then click the
Advanced button. This lets you save the settings as an import
specification. Subsequently, pass the name of the specification to
TransferText.
 

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

Export Spec Problem 1
Export to Tab delimited text file 4
Delimited Export Specification - independent of table 3
Import from text file with double quotes 3
Import Text Semi-Colon Delimited - Macro Issue 2
Counting records imported with the Transfertext method 3
Importing Text file with Strange Delimiter 1
I can't specify the Specification Name when use transfertext 1

Top