Importing Excel Work***

From: ChuckL (anonymous_at_discussions.microsoft.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 09:45:03 -0800

I'm running Access 97 and I am importing data from Excel.
I am encountering import errors as a result of access
reading the first row of the excel spread*** for field
type determination. Some of my fields begin with a number
(Row 1)but contain numbers and text in subsequent rows.
Basically, I am thinking I need to convert all fields to
text via the import process to retain all records.
I have tried formatting my spreadsheets as text - Access
still tries to convert my mixed fields to number. I have
also tried importing the spreadsheets to tables, deleting
the data, changing the data type to text, and importing
again to the same tables. This keeps all fields text, but
I am still losing records.
Is there anything I can do to solve this problem other
than entering text in the first row of the spreadsheets I
am importing so that Access assigns a text field type?
Thank you for your help. Greatly appreciated!