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.