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

Access Sql query to move data

P: n/a
Hi,
I am working on a database that was built for our operation, but the
only problem is that it has almost 2.6 million records in a table, so
it takes forever to run a report. I was wondering if there was a query
i could run that would remove certain records based on a date, ie
before may 2006 and add them to a different table, or database. Any
help is much appreciated.

Thanks,
zac

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


P: n/a
You have answered your own question

Write a query that would move (add then delete) data from one table to
another.

<za********@gmail.comwrote in message
news:11*********************@a75g2000cwd.googlegro ups.com...
Hi,
I am working on a database that was built for our operation, but the
only problem is that it has almost 2.6 million records in a table, so
it takes forever to run a report. I was wondering if there was a query
i could run that would remove certain records based on a date, ie
before may 2006 and add them to a different table, or database. Any
help is much appreciated.

Thanks,
zac

Jan 12 '07 #2

P: n/a
za********@gmail.com wrote:
I was wondering if there was a query
i could run that would remove certain records based on a date, ie
before may 2006 and add them to a different table, or database. Any
help is much appreciated.
Hi Zac,

No offence intended, but your question means you know very little about
MS Access or databases in general. 8) Of course, that's why you're
asking here! Nonetheless, I would strongly NOT recommend you start
tinkering with such a resevoir of records and knowledge without some
more experience - you don't learn to fly jets (MS Jet pun intended)
starting off on stealth fighters - you start off on trainer aircraft.
You should be doing the same thing with your database, otherwise you are
putting the "memory" of your organization's transactions in jeoprody.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Jan 15 '07 #3

P: n/a
Really valid point. Maybe you want to start with a book on SQL as a
language, so that you can write some queries with relative ease, or
maybe just one of the MS Access training guides. I would also suggest
that if you want to play with this database, you make a copy of it
first, and play with the copy.

To SELECT certain records FROM a table or existing query WHERE a
condition is met is actually not so hard, and is probably the best
place to start. If you can limit the number of records that you have to
deal with then all then you are half way there.

When looking for a good source of information on MS Access and the Jet
database in general, I have found that the MS Press books are great
(Running MS Access, Building Applications with MS Access), and the
author John Viescas really knows his stuff and can explain it in plain
english.

The other part of achieving your goal is to be able to take that data
you have found (the limited set you have selected from the master set),
and use it to populate a table so that the next time you can simply ask
your queries to the smaller table. For this you need to know a bit more
about MS Access, and again a good book or course will help you a great
deal. Its not so hard to do, but you do need to know what you are
doing, and for that you need information.

This is the MS Press booklist with information on most all MS Press
Books:

http://www.microsoft.com/mspress/fin...ist/title.aspx

I hope this gets you on the way. I know it can seem a little daunting,
but dont fear, the learning curve is very quick and you should be able
to do what you want without spending too long learning it.

Cheers and good luck

The Frog

Tim Marshall wrote:
za********@gmail.com wrote:
I was wondering if there was a query
i could run that would remove certain records based on a date, ie
before may 2006 and add them to a different table, or database. Any
help is much appreciated.

Hi Zac,

No offence intended, but your question means you know very little about
MS Access or databases in general. 8) Of course, that's why you're
asking here! Nonetheless, I would strongly NOT recommend you start
tinkering with such a resevoir of records and knowledge without some
more experience - you don't learn to fly jets (MS Jet pun intended)
starting off on stealth fighters - you start off on trainer aircraft.
You should be doing the same thing with your database, otherwise you are
putting the "memory" of your organization's transactions in jeoprody.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Jan 16 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.