Upsizing a large table from Access to SQL Server 2005 Express

[Mike T]

I'm trying to upsize an Access 2003 table into SQL Server 2005 Express and it
seems to be timing out before the upload is complete.

I've followed the instructions @ http://support.microsoft.com/kb/295231 but
that doesn't stop Access timing out.

Usually times out around 15 mins.

Anyone out there have any suggestions on how to get a large table into SQL
Server?

I've looked at SSMA for Access, but it has it's own problems!

Cheers

-- Mike

[Jeff Boyce]

Mike

Do you already have the table defined in SQL Server?

If so, you could link to that table and use a query to append records from
your local table to the SQL-Server table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Post by Mike T
I'm trying to upsize an Access 2003 table into SQL Server 2005 Express and it
seems to be timing out before the upload is complete.
that doesn't stop Access timing out.
Usually times out around 15 mins.
Anyone out there have any suggestions on how to get a large table into SQL
Server?
I've looked at SSMA for Access, but it has it's own problems!
Cheers
-- Mike

[Mike T]

Hi Jeff,

Yes, the table was created in SQL Server and linking to it via Access and
appending records to it got the data into SQL Server.

It solved the problem of getting data into SQL, but I'm still bugged as to
why Access is still timing out using the upsize Wizard.

Thanks for your help.

-- Mike

Post by Jeff Boyce
Mike
Do you already have the table defined in SQL Server?
If so, you could link to that table and use a query to append records from
your local table to the SQL-Server table.
Regards
Jeff Boyce
Microsoft Office/Access MVP

Post by Mike T
I'm trying to upsize an Access 2003 table into SQL Server 2005 Express and it
seems to be timing out before the upload is complete.
that doesn't stop Access timing out.
Usually times out around 15 mins.
Anyone out there have any suggestions on how to get a large table into SQL
Server?
I've looked at SSMA for Access, but it has it's own problems!
Cheers
-- Mike

[Jeff Boyce]

Yah! I have a few of those "why did it do that?" that I've never gotten
answered, too.

Mostly, though, I just pick the hammer back up and keep driving nails...<g>

Regards

Jeff

Post by Mike T
Hi Jeff,
Yes, the table was created in SQL Server and linking to it via Access and
appending records to it got the data into SQL Server.
It solved the problem of getting data into SQL, but I'm still bugged as to
why Access is still timing out using the upsize Wizard.
Thanks for your help.
-- Mike

Post by Jeff Boyce
Mike
Do you already have the table defined in SQL Server?
If so, you could link to that table and use a query to append records from
your local table to the SQL-Server table.
Regards
Jeff Boyce
Microsoft Office/Access MVP

Post by Mike T
I'm trying to upsize an Access 2003 table into SQL Server 2005 Express
and
it
seems to be timing out before the upload is complete.
that doesn't stop Access timing out.
Usually times out around 15 mins.
Anyone out there have any suggestions on how to get a large table into SQL
Server?
I've looked at SSMA for Access, but it has it's own problems!
Cheers
-- Mike

[Alex Dybenko]

Hi,
normally I make a copy of mdb, empty it (or leave only small tables), then I
upsize, and then in copy big tables to already upsized database, using
queries or transferdatabase method
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Post by Mike T
I'm trying to upsize an Access 2003 table into SQL Server 2005 Express and it
seems to be timing out before the upload is complete.
that doesn't stop Access timing out.
Usually times out around 15 mins.
Anyone out there have any suggestions on how to get a large table into SQL
Server?
I've looked at SSMA for Access, but it has it's own problems!
Cheers
-- Mike