asked on

Transfer Text - Character missing from input data

If I manually import a .csv file in an access table, I have no problem. However I am now trying to use Transfer Text in a macro to import the data. When I do the import using Transfer Text, the first character of the third column of data is missing in the table. For example, if a cell in the the third field in the.csv contains K11, the table field contains 11.(Note - the fomat of the data in this field is a letter followed by a number such as K11, J5, etc. ) I do get an error stating type converion error, but the table field is text.
I'm confused and could use your help! Thank you.

Rey Obrero (Capricorn1)

are you using an import specification? try editing the import specification

kshumway

ASKER

I guess I'm not sure what an import specification is. I've attached how the Transfer is set up in the macro. If there is something more, please enlighten me! Thank you!!!
EEAttach.doc

Rey Obrero (Capricorn1)

there is no import specification used in the macro.

try importing the csv to a non-existing (new) table

kshumway

ASKER

When I use a new table, it pulls the values in as currency. Instead of using the macro, I used the statement:

DoCmd.TransferText acImportDelim, , "tblNew", _
"\\ksqldb\dbapps\KathyTest\SpecimenCount\SpecimenCnt.csv", False

The second parameter is the specification? How would I set one up?

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kshumway

ASKER

That worked! Thank you so much!!!!!

kshumway

ASKER

Worked perfectly!!!! Thank you.