Stop Access from changing data type

  • Thread starter Thread starter H0MELY
  • Start date Start date
H

H0MELY

I am trying to import data from a .csv file using the “transfertext†command
in a macro. The data is to be transferred into a previously designed table
with the data types predetermined. Unfortunately Access insists on reviewing
the data on import and rejecting the data it doesn’t like.

Basically there are around 55,000 records. The field that Access has
trouble with has about 52,000 numeric cells and 3,000 text cells. Access is
rejecting the text cells even though the table the data is being imported
into has the field data type of “text.â€

I have long had issues with Access wanting to change the data type in my
data. Individually I can work around this, problem is that this particular
database is being distributed, so I have to make sure that the tool provides
accurate data and is user friendly. Is there anyone out there who can tell
me how to stop Access from trying to determine data types?

Thank you in advance for everyone who looks at this post. I appreciate any
advice that will be offered.

-john
 
did you create an Import Specification that explicitly defines the field in
question as Text data type?

hth
 
It is not Access changing data types. It is the code that does importing and
exporting. Try creating an import specification. That should take care of
your problem.
 
Back
Top