Hi,

I have a database in MS Access, and I want to copy the table structures
and data over to a SQLExpress database. Could someone please advise what
the best way of doing this would be? Do I need to create all the tables
manually, then copy the data, or can I do it all in one fell swoop?

Also, once I've copied the data, how would I copy my database from one
machine to another on the network, so that I can access it from the new
computer? Is it simply a matter of copying the data files, or is there
more to it?

Many thanks for any advice, it's much appreciated.

[quoted text, click to view]


Hi, Further to my message above, I have now created all the tables
manually and I am now trying to copy the data over to the SQLExpress DB.
I am using an Insert Into query in access to copy the data from my
Access table into the SQLExpress table. However, only one record gets
copied, and it is duplicated as many times as there are separate records
in the original table.

For example, if I have a table in access like this:

Col A Col B Col C

1 1 1
2 2 2
3 3 3
4 4 4
5 5 5


And run my query, the destination table contains:

Col A Col B Col C

1 1 1
1 1 1
1 1 1
1 1 1
1 1 1


Does anyone have any idea why this would be, or what I need to do to fix it?

Many thanks for reading.