how to convert excel 2000 to access 2000

W

W E B G U R L

I could find a MS tech note but for different versions.

I have an Excel 2000 spreadsheet with no blank columns to convert to Access 2000 where I
have to assign a primary key to be used for the web. I could do this but as it was linked,
Access told me I cannot assign a primary key.

What am I doing wrong?

thanks
 
A

Arvin Meyer

W E B G U R L said:
I could find a MS tech note but for different versions.

I have an Excel 2000 spreadsheet with no blank columns to convert to Access 2000 where I
have to assign a primary key to be used for the web. I could do this but as it was linked,
Access told me I cannot assign a primary key.

What am I doing wrong?
Click to expand...

Nothing. You cannot assign a primary key on a non Access object (except in
an adp file for SQL-Server).

You can import the Excel data into an Access table and assign a key, but the
2 will no longer be linked.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top