TYPE CONVERSION FAILURE - text to text field

  • Thread starter Thread starter Rony
  • Start date Start date
R

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
 
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
Click to expand...

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.
 
Hi
No I am trying to import text data to a text field in to acesss(Like J03)
--
Ron


[email protected] said:
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
Click to expand...

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.
Click to expand...
 
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
Click to expand...

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