Help! I need to migrate MS Access to MS SQL

The problem is it is too big! (77K rows in one table)

[itisgene]

Yes, I tried upsizing and Enterprise manager's import. They failed after about an hour of attempt. The process just generates temporaryupsizedfile(something like this) table.

One of the tables has 77K rows and I think it is too big to be imported to MS SQL Server from MS Access MDB file. Is there any way that I can populate the table? Every other table was imported correctly. But without the table, it is useless.

Any help would be appreciated.

[wackal]

try this:

In Access, copy the table and then paste. select that you only want to paste table structure.

upsize this new blank table to ms sql server

link the sql server table to access using odbc link.

create an insert query that will pull all records from access table and insert into sql server table.

[itisgene]

"link the sql server table to access using odbc link.

create an insert query that will pull all records from access table and insert into sql server table
"

Yes, I was going to try this.
I have done this a few years ago...I will have to brush my memory...

I already put the blank tables successfuly with all the structures in it.

It is just matter of inserting the data, hopefully using ODBC links as you suggested.

If Slurp bombards the site, the site goes offline due to the Access connection.

I need to fix this...

Thanks for the suggestion.

[tomasz]

You need to use DTS and select Access as your source and destination your newly created db then select all tables and DTS will do the rest.