I would start by importing it as a text field. Then I would take a look
to see exactly what the problem was and form a plan of action from there.
I believe you could play with a query to find and/or change data as
needed using something to identify any filed not exclusively numbers and add
the apostrophe or clear it or whatever works for your needs.
--
Joseph Meehan
Dia's duit
* Insert a "calculated" Column next to the MixedColumn using the function
TEXT() as follows:
= TEXT([CorrespondingCellInMixedColumn], "General")
for all cells in this Column. Save and close the Excel file.
* Link the Excel file to Access, ignore the original MixedColumn and use the
"calculated" Column. All values in this Column will be Text so the values
won't have #NUM entries.
--
HTH
Van T. Dinh
MVP (Access)
"GolfGal" <gol...@noemail.com> wrote in message
news:3B6EE351-055F-4531...@microsoft.com...