October 29th, 2004, 11:00 PM
|
 |
Contributing User
|
|
Join Date: Oct 2004
Location: Honolulu
Posts: 184
Time spent in forums: 20 h 29 m 2 sec
Reputation Power: 8
|
|
|
you could create the ms access application object, open a database (or create new one), then from there you execute any you want that you can normally do from code in access
Dim oApp As Object
Set oApp = CreateObject("Access.Application")
oApp.Visible= True ' if you want to see it
read up on the following:
OpenDatabase (dbname, options, read-only, connect)
TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)
example, like so with oApp:
oApp.DoCmd.TransferText( .....enter args)
don't forget when done to:
oApp.quit
Set oApp = Nothing
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
