msaccess table import to MSSQL 7.0 table

Benson Wong

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

msaccess table import to MSSQL 7.0 table

I want to know how to import (upgrade) a msaccess table to a MSSQL 7.0
table:

1. in msaccess database there is a table named, customer (1000 records) and
in MSSQL 7.0 there is also a table named, customer (no record, minor diff.
structure).
2. in MSSQL 7.0 customer table may have stored procedure and diff. index
from that of msaccess. How to know whether it has stored proc. ?
3. customer no. in customer table is autoinc in both database. Also some
records may be deleted (ID:1,2,4,5,8,10).

1. How to upgrade or convert or transfer the data from msaccess to MSSQL
7.0?
2. How to handle the autoinc key? if you modif MSSQL stru., it may break
some foreign key or rules.

Benson.
D5, MSSQL7.0, WINNT 4.0, CWIN98, ADO.

Kevin Frever

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:msaccess table import to MSSQL 7.0 table

Benson,

Check out MSSQL's DTS.

Good luck,
krf

Quote

Benson Wong wrote in message <8mp4ai$8...@bornews.borland.com>...
>I want to know how to import (upgrade) a msaccess table to a MSSQL 7.0
>table:

>1. in msaccess database there is a table named, customer (1000 records) and
>in MSSQL 7.0 there is also a table named, customer (no record, minor diff.
>structure).
>2. in MSSQL 7.0 customer table may have stored procedure and diff. index
>from that of msaccess. How to know whether it has stored proc. ?
>3. customer no. in customer table is autoinc in both database. Also some
>records may be deleted (ID:1,2,4,5,8,10).

>1. How to upgrade or convert or transfer the data from msaccess to MSSQL
>7.0?
>2. How to handle the autoinc key? if you modif MSSQL stru., it may break
>some foreign key or rules.

>Benson.
>D5, MSSQL7.0, WINNT 4.0, CWIN98, ADO.

Other Threads

1. Help, open tables with Delphi 4, MsSql Server 7.0

2. Problem accessing MSSQL 7.0 table with TTable

3. table ownership in MSSQL 7.0

4. problems moving to last record in a 30000 record table wih mssql 7.0

5. Delphi + MSSQL 7.0 cannot open more than 32 different tables

6. joining a paradox table to an MSAccess table in an SQL query

7. how copy contents from Paradox table into an MSAccess table

8. write query-table into a msaccess-table

9. import data from an EXCEL table to a paraxox table

10. Inf on using MSSQL local temporary tables (#Tables) in ADO