What i do is import the info. That is fine.  I then go to the DB, right click on teh table, select design table.  A design window comes up. I...

but how without it telling me i can't have a null pk?

Waht i mean is that i can import hte info without a problem. I just DON"T KNOW HOW to...

The original table is in access.  I use the import/export wizard. Created a query to get the unique info i need.  it places it into a table that either i've...

You are wonderful guys.  Phill thanks for the info on the destination table.  The wizard doesn't appear to always allow you to change destination info. I guess this has to...

I'm using the Import/Export Wizard.  I can create the query but it uses "create destination table" instead of "append rows to destination table" already in the db (which is usually...

I'm using the import/export wizard.  I select the "copy tables(s) and view(s) from teh source database option and press next.

It then takes me to a screen of Source and Destination...

This problem is resolved. thanks!

I need to take off the password protection.

Ok, this problem is resolved. I hope that that will be the last one for this issue.

Thanks guys. I got the password off that was the problem.

I think it is the fact that the file is password protected. How do i get it off. I tried using the Access password but it is not satisfied. When...

It works if i take the password off so how do i do that? I'm assuming that is the problem and what was meant by workgroups.

"unless the Access database has had login enabled for a workgroup."

I don't think i have a password for workgroup.  It is just a simple db file.

NO ONE HAS EVER HAD...

Guys, I'm still having problems when i try to use the Import/Export wizard.  When i put in that it is an MS Access document taht i'm importing from it asks...

No! No! No!  I think you misunderstand me. I built a database in sql server 2000. Now i want to transfer in info into it. So at present i have...

Oh, sorry. I just mean that the names are different. The column exist under a different name.

Sorry, you lost me. 🙂 

All i want to do is tranfer my data from my Access DB into my SQL Server DB which i've created.  I don't want to...