Importing Excel spreadsheets

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

compunow

hello,

I got some feedback already but the same problem exists.

Error message:
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.

i cleared the names of all reserve names and symbols. Still stumped.

here are my fields:


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




what am i missing
 
Conceivably the UsedRange property of your worksheet has got out of
synch with the contents you can see.

Try defining the area occupied by your Excel table as a named range
(Insert|Name|Define), and then specify that name when you import.
Alternatively select all the empty columns to the right of the Excel
table and delete them, then import the worksheet.
 
I always copy paste the data to a new worksheet and that solves this kind of
problem too.
 
Back
Top