Text Column

[Guest]

Hey guys,

If I have a 1V and a 16 in the same column, will access import both these
fields under text? Under what data type do I import them?

Thanks.

Andre Adams
Loop Capital Markets

 

[John W. Vinson]

Hey guys,

If I have a 1V and a 16 in the same column, will access import both these
fields under text? Under what data type do I import them?

Import from... what? Excel? Some other database? a text file???

GUESSING that you're talking about Excel:

If 1V is a valid value then the Access field must be Text. That's not a
number.

Access will look at the first few records of a table and *guess* what's the
appropriate datatype. Since Excel does not have strong datatyping, it must do
so by inspecting the content of the cells - and if the first nonnumeric value
is below the range that it checks, it will guess wrong.

I'd suggest creating a table with the fields defined with appropriate
datatypes and sizes, *linking* to Excel rather than importing, and running an
Append query to move the data into your table.

John W. Vinson [MVP]

 

[Steve]

I assume you are importing the data from Excel. Access looks at the values
in the first few records and "guesses" the data type. So if it sees data
like 1V it will correctly guess text. However, if it sees data in the first
few records like 16, it will guess numeric. In this case, you can set the
data type before importing.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Sorry for not responding. It worked. Thanks for your help!