TransferText: letters problem

[@lex]

I created a macro with TransferText for import a CSV file which have 2 columns (F1 - text, F2-integer).

Numers fields (F2) was imported correctly, but fields with letters (F1) remains empty after you perform the import.

Does anyone have any ideas?

10X

 

[@lex]

input file *.csv

123, 111
ABDF, 222
ABFX, 333
ABSE, 444
456 , 555

output file in db:
-----------------
| F1 | F2 | id |
-----------------
| 123 | 111 | 1 |
-----------------
| ... | 222 | 2 |
-----------------
| ... | 333 | 3 |
-----------------
| ... | 444 | 4 |
-----------------
| 456 | 666 | 5 |
-----------------

... - places of letters

 

[spikepl]

One time, use the wizard for importing the file. It will let you save a reusable specification for how data is treated.

 

[@lex]

The objective is to implement an automatic import procedure.

As I wrote above: I collect data using a script in a CSV file, and after that I need to add collected info in the database access. (for numbers records - no problems) but for records with text --> imported rows are empty.

 

[spikepl]

and since your automated import procedure does not import the data as desired, then do what I suggest, and amend your automated import procedure to include the ImportSpecification created as described

 

[batesonm]

Hi I am new to Access so please be gentle with me.

I know that this has not been updated in a long time so am hoping that someone will be able to help.

I have followed the process above. When I import the csv manually it all works fine. When I add this to a macro using the import specification it comes up with errors based on the file conversion which is I can not understand.

If anyone can shed some light on this would be great.

Many thanks

 

[batesonm]

Just want to clear up what is actually happening. When I follow the import wizard and do not go to advanced and save the specification name the CSV I have imports fine with no errors.

When I save the specification name and import the CSV it comes up with error table with file conversion errors.

I have checked all the field types and they should accept the CSV.

Hope this all makes sense, thanks in advance for any help or suggestions.

 

[batesonm]

There have been a fair few views of this but not answers. Does anyone have any ideas or point me in the right direction?