Missing Primary Key and Scrambled Data

G

Guest

Hi All,

I'm trying to import Excel 07 files into Access via the import wizard. I
let Access add the primary key. However when I open the file in design
view, no fields are selected as the primary key. In addition, in Query
design, no relationships are established. What happened?

Also, does anyone know why Access occasionally scrambles the order of the
rows? It’s quite frustrating!!!!

Thanks,

John
 
G

Guest

Letting Access add a primary key does not use any of the existing fields in
the spreadsheet. It will add a field that is an autonumber field.

Importing to a new table does not establish any relationships.

The physical order of rows in a relational database is not important.
Unlike a spreadsheet, it has no meaning for an application. You establish
the order when you use the table in a query, a form, or a report.
 

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

Importing SSNs from Excel into access 2007 and using as primary ke 1
Importing Data and Primary Key 2
Import with access defined primary key from macro 1
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Importing Data when primary key already exists 2
Importing and modifying exisiting primary key data 3
Data from excel into access then from one to many tables 0
How do I add an auto primary key to data imported on a regular bas 5

Top