Importing an Excel worksheet into Access

[Guest]

I am opening an Excel worksheet and going through the wizard in Access. But
the data type is being assumed and thus is screwing up my data.

For example, the licensenumber column is being defined as "number" and it
contains alphanumeric data.

Is there any way around this???

Thanks in advance for your help.

wnfisba

 

[KidSensation]

I am opening an Excel worksheet and going through the wizard in Access. But
the data type is being assumed and thus is screwing up my data.

For example, the licensenumber column is being defined as "number" and it
contains alphanumeric data.

Is there any way around this???

Thanks in advance for your help.

wnfisba

If you're importing into a new table the wizard will take you to a
step where you can walk through each field and change the data type to
whatever you want. However, if you're importing into an existing
table, this step is skipped.

 

[Dean]

I think that it looks at the values in the 1st row of data, try putting in
some bogus data in the excel file in the 1st row.

 

[Pat Hartman \(MVP\)]

This bug has existed in Access for a long time. When you link or import
excel spreadsheets, Access shows you what it interprets as the data type but
won't let you override its choice. You can't get past the problem if you
are linking to the table unless you can add a bogus row at the top of the
sheet to force a particular data type. If you are importing the sheet, the
best method is to import into an existing table which has the columns
properly defined.