Type conversion failure

[Guest]

I have a brand new - blank - db table to which I am trying to import an excel
file. Most of the data are numeric, but I have the field type set to text
because a select few do have a single letter after their 4 digit number. It
is these 8 alpha-numeric rows that is giving me the type conversion failure.
I cannot understand why. This particular column is my primary key data - but
I don't see how that would matter.

 

[Guest]

Start in Excel. Make sure that you have the column formatted as Text in
Excel. If necessary do Text to Columns from the Data menu. Click Next, Next,
select Text then Finish. Save and close the spreadsheet.
When you go to Import in Access, on the Import Spreadsheet wizard, click
next , next, then on the third screen, make sure to scroll over to the right
and select the problem column and make sure that Access is set to import that
particular column as Text.

Now, If the table already exists and you are not importing, but actually
appending via query or code, make sure that the field in Access is the
correct data type (text) beforehand.

If all else fails......use the lowest common denominator - text file
Export the data from Excel into a text or csv file then import the text file
into Access.

jmonty

 

[Guest]

Hi, thanks for the quick response. You're right - the table is made and I am
appending not importing even though the table is empty. I did make sure the
format in excel was text - no dice. What I finally tried that did work was I
took those last 8 rows that did not "append" through the import feature and
instead copied then paste-appended them into access. That, for some reason,
worked. Access glitch? I'm going to recreate the situation following your
instructions below to see if that will save me the copy/paste append step.
Thanks, again.