TransferText action not working properly

[Dennis]

In Access 2003, I've setup a TransferText action, to programmatically import
tables into a database. No problem, except that the import process isn't
recognizing the Tab delimiters of the row data. Here's what I'm using:

DoCmd.TransferText acImportDelim, , TableName & "TEMP", FullName, -1

Since the character is a Tab, I don't think I need to have a value for the
SpecificationName (at least that's what the Help facility tells me - that I
don't need a specification. If I do, how do I create one, and can I use the
same one for all the files I import?)

Note that all the columns end up as a single column in the table.

Any thoughts on this issue would sure be appreciated.

TIA!

 

[Mike Painter]

In Access 2003, I've setup a TransferText action, to programmatically
import tables into a database. No problem, except that the import
process isn't recognizing the Tab delimiters of the row data. Here's
what I'm using:

DoCmd.TransferText acImportDelim, , TableName & "TEMP", FullName, -1

Since the character is a Tab, I don't think I need to have a value
for the SpecificationName (at least that's what the Help facility
tells me - that I don't need a specification. If I do, how do I
create one, and can I use the same one for all the files I import?)

Note that all the columns end up as a single column in the table.

You must have a tabledefinition and I don't understand why help would say
such a thing.
(Tab delimited is rare ooutside the Mac world)
After you have defined the delimiter, field type and given them names if
needed, click on the Advanced button on the lower left. This will let you do
a bit more if needed and also save the definition with a name.

If teh files are all the same you can always use this name to import.

 

[Dennis]

Thanks. I have 23 tables and all are different. The only identical thing is
that the Tab character is the delimiter for the columns. So if I understand
you correctly, I need to go through a "manual" import process once, and
during that process define the table specification file for each.

 

[Mike Painter]

Yes.

Thanks. I have 23 tables and all are different. The only identical
thing is that the Tab character is the delimiter for the columns. So
if I understand you correctly, I need to go through a "manual" import
process once, and during that process define the table specification
file for each.