Importing excel spreadsheets

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

compunow

hello,

Error message:

The first row contains some data that can't be used for valid Access field
names. In these cases, the wizard will automactically assign valid field
names.

I downloaded KB: Q1109312 and cleaned the fields of all reserves. The
spreadsheet will not import after this.

There are alphanumeric field name such as ex Voice V1 and Data D1 is this
format causing a problem?

What about spaces such as ex: Phone Ext or Login Id

Please help
 
Spaces and alphanumeric characters for field names should be ok in ACCESS.
Post all the values that are in the first row of your spreadsheet and let's
see what you have.
 
These are the first row field names.

User Login ID Division Department Phone Ext Computer Asset Wall Jack
Voice V1 V2 Data D1 D2 Make Model Workstation Serail Number Operating
System SP English Japanese ZENworks Installed Computer ID MAC Address IP
Address Static Dynamic Link Speed Duplex Level IPX Installed Was IPX
Removed Hard coded DNS Was it Removed Parent Server Program Version Virus
Definition File Version Novel Client Version Revisit this Location Inspected
By Inspected Completed By Completed Comments Read Flaged
 
These are the field name being used.
User Login ID Division Department Phone Ext Computer Asset Wall Jack
Voice V1 V2 Data D1 D2 Make Model Workstation Serail Number Operating
System SP English Japanese ZENworks Installed Computer ID MAC Address IP
Address Static Dynamic Link Speed Duplex Level IPX Installed Was IPX
Removed Hard coded DNS Was it Removed Parent Server Program Version Virus
Definition File Version Novel Client Version Revisit this Location Inspected
By Inspected Completed By Completed Comments Read Flaged


thanks
 
Those look ok, so long as none of them start with a blank space.

Can you expand on what you mean by "The spreadsheet will not import after
this."? What error are you getting?
 
Back
Top