Import Excel Spreadsheet

  • Thread starter Thread starter compunow
  • Start date Start date
C

compunow

I am recieving a message that states:
The first row contains some data that can't be used for valid Access field
names. In these cases, the wizard will automatically assign valid field
names.

The spreadsheet contains alphanumeric names and it has 70 columns of data.
What is the best way to tell which field name(s) is causing the problems?

Could you import tables in design view?


Pls Help

Pls help
 
What is the best way to tell which field name(s) is
causing the problems?

The following would prevent the fieldname from importing:
- Name is longer than 64 characters
- Name contains a period, exclamation point, accents, or
brackets
- Has a leading space
- Name is an Access reserved word

For the latter, see:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;109312

HTH
Best regards.

Kevin Sprinkel
Becker & Frondorf
 
kevin,

Thank you for your response. I printed the KB and cleaned the field names
but I still cannot import the spreadsheet. Some fields are alphanumeric ex:
Voice V1, D2. Data D1 is this causing a problem?

Also what about spaces such as ex: LOGIN ID or Wall Jack.
 
Kevin,

Thank you very much. I will try letting access create the field names for me
and then change them. Will this affect me doing queries, form or reports
 
Thank you very much. I will try letting access create the
field names for me
and then change them. Will this affect me doing queries,
Click to expand...
form or reports

No, create the queries, forms, and reports based on the
table after renaming the fields to your preferred names.

If you intend to import data from this spreadsheet
regularly to append to existing data in the table, you
might want to do the following:

Rather than rename the fields Access automatically
assigned in the imported table,

- Copy the imported table first, structure only.
- Rename the fields in one of the tables. You may want to
also add an AutoNumber primary key.
- Create and save an Append query that posts the records
from the imported table to the table with the corrected
fieldnames. A unique key will be assigned to each
imported record.
- After verifying the records have successfully posted,
delete the records from the imported table.

In the future, you can then import the spreadsheet to the
table with Access-defined field names, and then simply run
your pre-defined query to post them to the table with your
field names. All queries, forms, and reports based on the
latter table will still be good.

Best regards.
Kevin Sprinkel
Becker & Frondorf
 
Back
Top