TYPE CONVERSION FAILURE - text to text field

[Rony]

Hi
I am trying to import data automaticaly from csv file to access database
In csv file data such as K01, J03, M05, imported as 1 , 3, 5, into access
databse and error table indicates "Type Conversion Failure"
Field in access table [ECO-SECTOR] - TEXT FIELD

Please let me know a solution

Thanks
Rony

 

[pietlinden]

Hi
I am trying to import data automaticaly from csv file to access database
In csv file data such as K01, J03, M05, imported as 1 , 3, 5, into access
databse and error table indicates "Type Conversion Failure"
Field in access  table [ECO-SECTOR] - TEXT FIELD

Please let me know a solution

Thanks
Rony

You mean you're trying to write text into a numeric field? That's the
problem. you need to explicitly cast it as an integer, using CInt
(value).

Post your code.

 

[Rony]

Hi
No I am trying to import text data to a text field in to acesss(Like J03)
--
Ron

Hi
I am trying to import data automaticaly from csv file to access database
In csv file data such as K01, J03, M05, imported as 1 , 3, 5, into access
databse and error table indicates "Type Conversion Failure"
Field in access table [ECO-SECTOR] - TEXT FIELD

Please let me know a solution

Thanks
Rony

You mean you're trying to write text into a numeric field? That's the
problem. you need to explicitly cast it as an integer, using CInt
(value).

Post your code.

 

[John W. Vinson]

Hi
I am trying to import data automaticaly from csv file to access database
In csv file data such as K01, J03, M05, imported as 1 , 3, 5, into access
databse and error table indicates "Type Conversion Failure"
Field in access table [ECO-SECTOR] - TEXT FIELD

Please let me know a solution

Thanks
Rony

Well, the text string K01 is not a number, and will not be interpreted as a
number. You'll need to specifically extract the numeric portion. If your
phrase "imported as" means that you're doing so, please explain.