type of data convertion error

T

thread

Hi all,
when i'm trying to import or just to make a linked table i found
errors in the some of the fields becaouse of the type of data
whenever there is a mix in one column between some that are numbers
and some that are chars the default is char but the numbers are
becoming error
how can i overcome the problem?
 
J

Jerry Whittle

Strange because it's usually the other way around where you have a number
field and an alphabetical character gets thrown in.

First some questions:
1. What type of file format are you trying to import or link? Text? Excel?
CSV?

2. What do you mean by Char data type? Access calls it Text and a text field
should easily handle numerical characters. A Char datatype in Oracle is a
slightly different beast than Text in Access. We need precise use of terms
here.

3. When does the error occur? Before, after, or during the import?

4. Are you trying to import into a new table or an existing table?
 
Top