By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 2,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

dump

P: n/a
Hello,

I have database in Ms Access. I create a tables using wizards. So,
now, how can i take a dump of that database. Please, guide me.

Thanks in advance.

May 9 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On May 9, 5:25 am, pwpradeep <pradeepwkulka...@gmail.comwrote:
Hello,

I have database in Ms Access. I create a tables using wizards. So,
now, how can i take a dump of that database. Please, guide me.

Thanks in advance.
what do you consider to be a "Dump"?? I think you need to be clearer
about what you are trying to achieve here.

In my world a dump is a complete backup of all tables in their native
format... all you need to do in access in that case is copy the
database backend (which is just the database file, assuming you didn't
split it, and if you are using the wonderful wizards of doom i'm
guessing you didnt.)

If you are looking to extract all the data in some kind of excel
readable format - then the easiest thing for a person in your position
to do is to select the tables one by one in the database window (press
F11 to reveal it if you can find it) and use the export to excel
utility.

If you need anything more complicated, then learn access

May 9 '07 #2

P: n/a
I think you are asking how to dump table info to excel step-by-step.
* First, open your Access Database.
* Then click on the 'Tables' icon on the left pane titled 'Objects'
* Now you have all your tables displayed on the main window
* Right click on the table you would like to export and choose
'Export'
* Select (a) the location where you would like to save this 'dump' and
(b) on the 'Save as type' drop down at the bottom of the dialog box
choose the export format [i.e. Microsoft Excel 97-2003 (*.xls)]
* Click on 'Export' and you're done.
You then need to repeat this process for every table you require
exporting.

May 9 '07 #3

P: n/a
Hi,

Dump means, i want SQL queries, which are creating table structures
and insert data. By this , i can use that queries in Oracle / MySQL.

Thanks

May 11 '07 #4

P: n/a
Hi, Pradeep.
Dump means, i want SQL queries, which are creating table structures
and insert data.
This functionality isn't built into Access. Access is meant to be a desktop
database, not a server database, which commonly does have this function
built in. But just because it's not a built in function doesn't mean you
can't have it. If you really need it, it will take you half a day to code
the automated DDL and inserts if you're an experienced VBA programmer.

Good luck.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"pradeep" <pw*******@gmail.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...
Hi,

Dump means, i want SQL queries, which are creating table structures
and insert data. By this , i can use that queries in Oracle / MySQL.

Thanks

May 11 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.