import spreadsheet disables data type option

K

Kate

Does anyone else have this problem? When using the import
spreadsheet wizard, I cannot specify the data type for the
fields, as that option is not enabled. It displays the type
that Access 'thinks' it should be, but won't let me change it!!

Very frustrated,
Kate
 
J

John Vinson

Does anyone else have this problem? When using the import
spreadsheet wizard, I cannot specify the data type for the
fields, as that option is not enabled. It displays the type
that Access 'thinks' it should be, but won't let me change it!!

Very frustrated,
Kate
Click to expand...

That's correct, unfortunately. Excel does not have datatypes - any
cell can contain anything.

I'd suggest creating an empty table in Access, with the desired
datatypes, and either importing into this table, or linking to the
Excel spreadsheet and running an Append query to populate the table.

John W. Vinson[MVP]
 
K

Kate

Thanks, John, for answering. I guess this is a wish list.
I know Excel doesn't have data types, but it would be nice
to be able to force Access into assigning them as we desire
(and particularly, the length of text fields so they don't
default to 255!). -Kate
 
Top