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

How To Dump All Tables To A Text File

P: n/a
Hi Gang

We have an Access 2003 database with lots of tables and data. I'd like
to dump all the data into a single text file for searching. Can I do
this somehow?

Thanks
Andy

Jan 10 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Andy" wrote
We have an Access 2003 database with lots of tables and data. I'd like
to dump all the data into a single text file for searching. Can I do
this somehow?
Yes you can, with VBA code. There's no built-in feature or function to do
so.

Larry Linson
Microsoft Access MVP
Jan 10 '07 #2

P: n/a
On 10 Jan 2007 14:10:06 -0800, "Andy" <an***********@siemens.com>
wrote:

What part of searching with SQL don't you like?

-Tom.

>Hi Gang

We have an Access 2003 database with lots of tables and data. I'd like
to dump all the data into a single text file for searching. Can I do
this somehow?

Thanks
Andy
Jan 11 '07 #3

P: n/a
"Andy" <an***********@siemens.comwrote in news:1168467005.707687.43120
@p59g2000hsd.googlegroups.com:
We have an Access 2003 database with lots of tables and data. I'd like
to dump all the data into a single text file for searching. Can I do
this somehow?
I can. I guess that right now, at least, you can't.

If we knew why you want to do this we might be able to suggest the best way
to achieve what you want, or a good way, or perhaps the least inefficient
way. Maybe we would suggest another way.

Then again we might send links to sites offering hard disk incineration.
Oops, I just corrected a typo that said hard dick incineration; oh my, now
I'm not going to be able to sleep!

--
lyle fairfield
Jan 11 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.