Article Link.

By "DTC/Import or export utility" I take it you mean DTS. I think DTS
would be perfectly suited to the job as this can be controlled
programmatically. In fact the entire package can be built within
VB/VBScript, and of course this enables you to dynamically change any
property you desire. The Wizard is just a quick and easy interface to
building your first package, but there is a complete object model
available for you to use.

Darren Green
SQL/DTS - http://www.swynk.com/friends/green/

PS why does this posting facility set the name to anonymous?

I want to be able to transfer database objects without using import/export utility.
Ideally i want to have a VB app that selects the tables I want to move, and moves them using a DSN-less connection.
Any ideas?

If I understand this question right you want to move data from Access to SQL progrmatically. I great feature of SQL 7 is Linked Servers. You can link any ODBC compliant datasource to SQL Server and it will act as if it is a table in SQL. So you can create a Linked Server with the code:

EXEC sp_addlinkedserver
'TMCAccess',
'OLE DB Provider for Jet',
'Microsoft.Jet.OLEDB.4.0',
'c:\myAccessDB.mdb'
----- This allows security to be turned off for this Linked Server
EXEC sp_addlinkedsrvlogin 'TMCAccess', 'false'

Then you can get to the data like this:

INSERT
Temp_tblMark
(
ID
, Text
)
SELECT
ID
, Text
FROM
TMCAccess...dbo_tblMark

Then you can delete the Linked Server like this:

IF EXISTS(SELECT * FROM master..sysservers
WHERE srvname = 'TMCAccess')
EXEC sp_dropserver 'TMCAccess', 'droplogins'

Hope this helps.

Greg McCarty
gregmccarty@hotmail.com