Search results

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.

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 |...

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