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
Printable View
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
but that doesn't create index files and withut index files the speed is very slowCode:SELECT [Id],[f] INTO [dBASE III;Database=E:\Documents and Settings\Administrator\Desktop\New Folder (3)].[e.dbf] FROM [Table1]
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