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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import data 1
Changing Data Type when importing Excel spreadsheet 2
Data type on import wizard not active 12
Import Spreadsheet missing field 8
Importing Excel spreadsheet into Access - data type problem 2
Import Spreadsheet Wizard problem 1
Data Type 1
Import Excel Spreadsheet 1

Top