exporting tables from access

how could i export a table from access in dbase format without using access core libraries if possible using ado or adox or even dao

thnks

This won't work for you?

VB Code:

Dim Myaccess As Access.Application
 
Set Myaccess = CreateObject("Access.Application")
 
With Myaccess
 
.Visible = False
 
.OpenCurrentDatabase (TimeDatabase)
 
' Try to replace this area for text files
 
.DoCmd.TransferDatabase acExport, "dbaseIV", "c:\osmsys\data\rarch", , "DATATABLE", "OUTSOURCE.dbf"
 
.Quit
 
End With

Why not?

i remember that James :) but that needs access installed no thats no good

Perhaps you could recreate the table in code. ;)

u could use a statemant like

Code:

---

SELECT [Id],[f] INTO [dBASE III;Database=E:\Documents and Settings\Administrator\Desktop\New Folder (3)].[e.dbf] FROM [Table1]

---

but that doesn't create index files and withut index files the speed is very slow

As a question - can you not use the statement you posted but then reopen it and add in the indexes?

Does it have to be dbase? Could be csv??


Vince

thnks for the effort Ecniv found the solution by using ADOX i think thats the best library ever :) very easy :) and cause i m little curius what exactly is cvs

text file comma separated variable

np... good that you found the answer :) ADOX is it then huh ? :)

Vince