Import from Excel returns Null records

D

Dale Fye

First time this has ever happened to me.

I'm working in Office 2K, and am trying to import some data from an
Excel spreadsheet. When I run thru the GetExternalData wizard, and
indicate No Primary Key, I'm getting back Null records (the right
number of records, but without any of the data). When I let Access
add a PK field, it reads the data correctly.

Anybody else familiar with this problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 -- Importing Text File -- Nulls 1
problem importing information from excel into access 0
some records will be imported from excel 0
Incorrect error msg: Null value in an auto-number field 0
import excel spreadsheet without empty rows (causing nulls) 4
Keeping Format Importing From Excel 4
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Importing SSNs from Excel into access 2007 and using as primary ke 1

Top