Excel Data Importing

[Guest]

I've got this Access97 soon to be upgraded to Access XP into which I am importing Excel data. It worked fine until just a few weeks ago. At the Excel level I have a named range, which has been horizontally extended by 23 more columns. All the fields in the target temp table are set to 30 characters text. This is to simplify the import process. However, now after the adding of additional columns I am getting data conversion errors all over the place beginning with the columns added to the right of the previously set range. I've made various adjustments to accommodate the changes and I am still getting those errors

Any suggestions, on solving this problem would be appreciated?

 

[Adrian Jansen]

If you are using the Import wizard, then it doesnt matter what the table
format is set to, if the wizard finds data in the first few rows of the
Excel sheet which are numeric, it will assume the data is all numeric, and
create an error when it finally finds one which can only be text. The
solution is to explicitly set the format of all the columns on the Excel
sheet as text. One way is to set a dummy value of text - eg any alpha
character - in the first row of every column. After the import, just delete
that record from the table.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

I've got this Access97 soon to be upgraded to Access XP into which I am

importing Excel data. It worked fine until just a few weeks ago. At the
Excel level I have a named range, which has been horizontally extended by 23
more columns. All the fields in the target temp table are set to 30
characters text. This is to simplify the import process. However, now after
the adding of additional columns I am getting data conversion errors all
over the place beginning with the columns added to the right of the
previously set range. I've made various adjustments to accommodate the
changes and I am still getting those errors.