G
Guest
I'm importing an Excel spreadsheet as a new table in my database. The Import
Spreadsheet Wizard does not allow me to choose the number data type. Instead
it assigns the data types and keeps the 'Data Type' box greyed out so that I
can't choose the number data type I need from the drop-down list.
For instance, for a field that clearly contains only small integer values,
it chooses Double. For fields where I would choose Single, again it forces
the Double data type though there is definitely no need for it (I know the
dataset quite well).
I would prefer to set the proper data types as I'm importing rather than
change them in the table design view later. How do I do this?
Thanks,
Pat
Spreadsheet Wizard does not allow me to choose the number data type. Instead
it assigns the data types and keeps the 'Data Type' box greyed out so that I
can't choose the number data type I need from the drop-down list.
For instance, for a field that clearly contains only small integer values,
it chooses Double. For fields where I would choose Single, again it forces
the Double data type though there is definitely no need for it (I know the
dataset quite well).
I would prefer to set the proper data types as I'm importing rather than
change them in the table design view later. How do I do this?
Thanks,
Pat