Copy all tables from SQL to MS access

grech...@ftsinc.com (Gabe)

Delphi Developer

Sat, 04 Jun 2005 00:30:55 GMT

Copy all tables from SQL to MS access

Could someone suggest a faster way to copy all tables from an SQL 6.5
database into a local MS Access 2000 (blank) database. I am using
Delphi and ADO. The table names may vary, however I obtain a string
list of them using TAdoConnection.GetTablesnames.
Opening each table and using record by record approach is quite slow.
Thanks
Gabe.

BlueG

Delphi Developer

Sat, 04 Jun 2005 01:37:42 GMT

Re:Copy all tables from SQL to MS access

Forgot all the nuances of SQL 6.5, but take a look at the BCP utility. Very
fast export of data that can then be imported into Access.

Quote

"Gabe" <grech...@ftsinc.com> wrote in message

news:3dfdfdcd.333488130@forums.inprise.com...

Quote

> Could someone suggest a faster way to copy all tables from an SQL 6.5
> database into a local MS Access 2000 (blank) database. I am using
> Delphi and ADO. The table names may vary, however I obtain a string
> list of them using TAdoConnection.GetTablesnames.
> Opening each table and using record by record approach is quite slow.
> Thanks
> Gabe.

Del Murrra

Delphi Developer

Sat, 04 Jun 2005 02:19:18 GMT

Re:Copy all tables from SQL to MS access

You might also set up a DTS package and run it from within your delphi app
using the winshellexec .

Michael Lun

Delphi Developer

Sat, 04 Jun 2005 04:06:34 GMT

Re:Copy all tables from SQL to MS access

Del,

Do know how to modify an exsting package or create on from within a Delphi
app (perhaps through COM)

Quote

"Del Murrray" <del.mur...@credithawk.net> wrote in message

news:3dfe175c$1@newsgroups.borland.com...

Quote

> You might also set up a DTS package and run it from within your delphi app
> using the winshellexec .

Gab

Delphi Developer

Sat, 04 Jun 2005 05:07:49 GMT

Re:Copy all tables from SQL to MS access

Thank you BCP is greate

Quote

On Mon, 16 Dec 2002 16:30:55 GMT, grech...@ftsinc.com (Gabe) wrote:
>Could someone suggest a faster way to copy all tables from an SQL 6.5
>database into a local MS Access 2000 (blank) database. I am using
>Delphi and ADO. The table names may vary, however I obtain a string
>list of them using TAdoConnection.GetTablesnames.
>Opening each table and using record by record approach is quite slow.
>Thanks
>Gabe.

Paul Lambadari

Delphi Developer

Mon, 06 Jun 2005 17:11:44 GMT

Re:Copy all tables from SQL to MS access

In article <3dfe303...@newsgroups.borland.com>, mich...@winvotes.com
says...

Quote

> Do know how to modify an exsting package or create on from within a Delphi
> app (perhaps through COM)

Two possibilities
- Import the Microsoft DTSPackage Object Library and use it your own
way; it's more easy to modify an existed package
- check http://www.sqldts.com

-------------------------------
Paul Lambadaris
Delta Singular S.A.
mailto : p...@NOSPAMsingular.gr
www : http://www.singular.gr

Euan Garde

Delphi Developer

Mon, 06 Jun 2005 18:13:23 GMT

Re:Copy all tables from SQL to MS access

Posted in .attachements is an old sample of mine for creating packages.

-Euan

Quote

"Michael Luna" <mich...@winvotes.com> wrote in message

news:3dfe303d$1@newsgroups.borland.com...

Quote

> Del,

> Do know how to modify an exsting package or create on from within a Delphi
> app (perhaps through COM)

> "Del Murrray" <del.mur...@credithawk.net> wrote in message
> news:3dfe175c$1@newsgroups.borland.com...
> > You might also set up a DTS package and run it from within your delphi
app
> > using the winshellexec .

Other Threads

1. Copy SQL Server Table to Access Table

2. CONVERTING ACCESS TABLES TO MS SQL TABLES

3. access to MS ACCESS / MS SQL without BDE?

4. copy table from SQL Server to Access DB (programmable)

5. Copying Access table to SQL server

6. SQL Like predicate with MS Access 95 Tables

7. autoincrement with SQL in MS-Access-table

8. Accessing Tables from an MS-SQL server throug the BDE in the Database desktop

9. Replication between MS SQL 7 and MS Access

10. MS SQL Server and MS Access