Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting a MDB database to a CSV or Other format

Status
Not open for further replies.

sircsaba

MIS
Oct 15, 2002
6
0
0
CA
Can anyone tell me where I can get a free program to convert a MDB database to any format : Excel, CSV, Paradox or DBF ??

Service Info-Rapide Inc.,
Customized Electronic Punch Systems (Homegrown)
 
Hi

If yopu are talking od exporting the data, then you do not need an additional program, Access includes this functionality as standard

From the menu see File \ SaveAs Export

You can achive same result in code using docmd.Transfertext, or possibly docmd.outputto



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
If you have Excel and you have rights to the data in the MDB you should be able to use the option in Excel of Get External Data from the Data option on the menu.

Hope this helps.

OnTheFly
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top