Office 2000

G

Guest

Is it possible to save an Access data base as either
A *.DBF
B: *.Dif
C: *.asci delimitted
Any pointers appreciated
Peter
 
D

Douglas J. Steele

You can't save an Access database as anything other than an Access database.

You can, however, save the individual tables within the database as either
..dbf or Ascii delimitted (not sure about .dif)

Through the GUI, select the table, go to Save As/Export and pick "To an
External File or Database". Pick the appropriate value in the Save as type
list. In some cases (like Ascii delimitted), you'll be presented with a
wizard to help you complete the export.

Programmatically, you can use the TransferDatabase method.
 
J

John Nurick

.dbf or Ascii delimitted (not sure about .dif)
Click to expand...

I think this requires exporting to .xls, opening in Excel and then
saving as .dif - or custom or third party software.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DBF file help 2
what steps are needed to import Lotus Approach files into Access 1
Data Access Page on Startup 1
Link to XLS or Import as DBF 1
Import Multiple Text files in Folder 3
exporting to a dbf file 3
Unexpected Error From External Database Driver (8458) 0
When will save as "DBF" be a reality from Excel 2007 ? 1

Top