Am MS Access 2000 DB To an SQL SERVER 2000?

One way is to add the Access database as a linked server and then INSERT
into SQL Server from that linked database.

EXEC sp_addlinkedserver
@server = 'ACCESS_NORTHWIND',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'C:\MSOffice\Access\Samples\Northwind.mdb'

INSERT INTO TargetTable (col1, col2, col3)
SELECT col1, col2, col3
FROM ACCESS_NORTHWIND...Orders

See sp_addlinkedserver in Books Online for more information.

--
David Portas
SQL Server MVP
--

.... That's assuming you have access to Query Analyzer or some other means of
issuing those SQL statements. If not, then you could create an Access 2000
ADP project and write a SQL stored procedure to do the job. Or, if you are
more at home with Access than SQL, create a linked SQL table in Access and
insert the data from there.

Hope this helps.

--
David Portas
SQL Server MVP
--

Hi

You may want to look at the Access upsizing wizard that is part of Access.

John

[quoted text, click to view]