how to change data type while importing

[Guest]

I am trying to import an excel spreadsheet into access. One of the fields had
data consisting of numbers and text numbers like cd1005. Now when I am
importing this into access, i am getting type conversion errors. No matter
what my format in excel is not preserved. Moreover I cannot see am option to
change the data type in the import wizard. Its preselected and it does not
change. Can anybosy help please. ITs urgent.

 

[Jeff Boyce]

Create a "temporary" import table in Access. Give it the data types you
need/want.

Import from Excel into that table.

Now parse the temporary data into its final correct format and into the
"permanent" tables.

Odds are pretty good that you'd need to do this anyway, since Excel data is
seldom well-normalized. You won't get good use of Access' features and
functions if you feed it a diet of 'sheet data.

Regards

Jeff Boyce
Microsoft Office/Access MVP