Solved Issues importing data with correct format (1 Viewer)

[NahualXl]

Hello,
I am executing the following command (operator enters the file number to be imported and press a button):

DoCmd.TransferText TransferType:=acLinkDelim, tableName:="CsvTbl", _
    FileName:="E:\Op60\" + MyTbl + Myextension, HasFieldNames:=True

to open a desired CSV (I have 100s of different files) file (generated automatically elsewhere), just realized there is an issue when importing a column named "DATA".
This field contains either numbers 1.0, 0.056 etc. or letters A, or B.
When the import operation takes place this field gets automatically formatted as Numeric, and where a letter value is found displays "#Num!" instead.
The import operation creates a linked table from each file opened, thus making it impossible for me to edit the field and correct the formatting.
If any one has any ideas as to how to correct this or another solution I'd appreciate it so much.
Thank you

 

[theDBguy]

Hi. Have you tried creating/using an import specification?

 

[NahualXl]

Hi. Have you tried creating/using an import specification?

hello, I am sorry I do not know how to do that..

 

[theDBguy]

hello, I am sorry I do not know how to do that..

Check out this site.

Automate Your Import Process in Access | The Office Corner (mauriceausum.com)

 

[NahualXl]

Check out this site.

Automate Your Import Process in Access | The Office Corner (mauriceausum.com)

Thank you so much!

 

[theDBguy]

Thank you so much!

You're welcome. Hope it helped!

 

[Pat Hartman]

Without a specific importSpec, Access reads the first 30 or so rows of data. If ALL the values in column4 are numeric, Access assumes that all rows contain numbers. If there is a mix, Access assumes a text data type. This is what you are running into and why your import may work occassionally but not other times.