Export Access Table

[komark]

Hi,
I was just wondering if I can export a table from an access dB into excel without opening the access db?
I was wanting to do this VBScript so I can run a Windows Scheduler to automate the whole process.

Thanks in advance
Omar

 

[PHV]

Have a look at the /x command line option of msaccess.exe

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jfdabiri]

i think this is what you need:

db_path = "c:\directory\access_db.mdb"   
Set objConnection = CreateObject("ADODB.Connection") 
objConnection.Open _
   "Provider = Microsoft.Jet.OLEDB.4.0; " & _
   "Data Source = " & db_path  
commandstring = "SELECT * INTO [Excel 8.0;HDR=Yes;" & _
        "Database=c:\where\excel\file\should_go\ &
          excel_name & ".xls].Sheet1 FROM " &  tbl_name   
objConnection.Execute commandstring