- Joined
- Jul 26, 2005
- Messages
- 2
- Reaction score
- 0
Type conversion Error - Importing from csv file
Hi,
I'm using vba to automatically export csv files to a table.
The table is already set up as Mytable (fielda text, fieldb text, fieldc date, fieldd text).
Fieldd is the tricky one. It contains numeric looking values and proper text value (for example 6530, 6789, f d890).
When importing the csv files all the text value (like f d890) are not imported, and access return the row in an error table with a "type error conversion" explanation.
How can I sort this out?
How can I push access to import everything without deciding what is a good and a bad value for the field.
I've seen that other people had similar issues but did not see any solution to this.
Anyone can help?
Regards
Hi,
I'm using vba to automatically export csv files to a table.
The table is already set up as Mytable (fielda text, fieldb text, fieldc date, fieldd text).
Fieldd is the tricky one. It contains numeric looking values and proper text value (for example 6530, 6789, f d890).
When importing the csv files all the text value (like f d890) are not imported, and access return the row in an error table with a "type error conversion" explanation.
How can I sort this out?
How can I push access to import everything without deciding what is a good and a bad value for the field.
I've seen that other people had similar issues but did not see any solution to this.
Anyone can help?
Regards
Last edited: