How to transfer a database from MS Access to MS SQL

aboakai · #1 (**permalink**) 02-09-04, 04:08

Hi all,
How to transfer a database from MS Access to MS SQL? Is there some tools?

mirtheil · #2 (**permalink**) 02-09-04, 07:55

I believe there's an upsizing tool but this is the wrong forum to post. You'll really want to post in the MS SQL forum rather than the Pervasive.SQL forum. This forum is for the Pervasive.SQL database not MS SQL.

Dilyias · #3 (**permalink**) 02-13-04, 03:01

Quote:

Originally posted by aboakai
Hi all,
How to transfer a database from MS Access to MS SQL? Is there some tools?

Just use the DTS Import tool in the Sql Server Enterprise Manager. In the source section choose MS Access and locate the mdb file.

Internet Services

Web Development

Digital Marketing

Consumer Tech