exporting tables from access

[tina104291325]

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

[James Stanich]

This won't work for you?

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?

[tina104291325]

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

[James Stanich]

Perhaps you could recreate the table in code.

[tina104291325]

u could use a statemant like

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

[Ecniv]

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

[tina104291325]

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

[Ecniv]

text file comma separated variable

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

Vince