Export Access Database to DBF file thourgh Macro

[gssachin]

hi,

I m fresher & jst started using Access 2007, How Can I export my Access table in DBF format through macro
In Macro
I selected Trasfer type : Export
Database Type : Microsoft Access
Database Name : C:\NEWJOIN.accdb
Object : Table
Sourch : SNEWJOIN (my table name in my "Newjoin.accdb" file)
Destination : d:\SNEWJOIN.DBF
Structure Only : No

But I m getting error "The Object Name D:\snewjoin.dbf you entered doesn't follow MS Access object-naming rules

Please do the needful.

Thanks & Regards,
Sachin

 

[Joe4]

Have a look here: Exporting Table to DBase IV (*.dbf) with VBA - Access World Forums

 

[gssachin]

Dear Joe4,

Thanks for reply.

I check your link but still I m getting error "Runtime error 3011" - The microsoft access database engine could not find the object "snewjoin"

 

[james_lankford]

does your table have memo fields ?
I don't think they work with dbf

 

[gssachin]

Dear James,

No I don't have any memo fields in my Table...

 

[gssachin]

Bingo I Got solution

I Changed my Details as follow
I selected Trasfer type : Export
Database Type : dBASE IV
Database Name : D:\
Object : Table
Sourch : SNEWJOIN (my table name in my "Newjoin.accdb" file)
Destination : SNEWJOIN.DBF
Structure Only : No

It's work for me