Access to SQL SErver7

[Kinl]

Ok,
I"ve never done any insertions from cross platform RMDBS before, so here we go.
I have SQL Server 7.0 which has all of our data, and this is what we are always going to use. I have an Access Database with 8000 records in it, and these records need to be selected, and then inserted into 3 tables on the SQL server. This process will only happen once. How should I go about doing this? How do I open Access and input into SQL Server?

Thanx,

shorty

 

[tlbroadbent]

One way to export from Access is to link the SQL tables and write queries in Access that select data from the Access tables and append to the linked SQL Server tables. It is simple and effective for one shot operations. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[jimmythegeek]

Use DTS (Data Transformation Services) in SQL Server. Go to your database in SQL Server. Right Click, and go to All tasks | Import Data. You will get a wizard that will walk you through importing data from any data source, including an Access database. You can select to import the data into an existing table, or a new table,

It is simple once you do a couple of times. Jim Lunde
compugeeks@hotmail.com
Custom Application Development