Hi, I just imported like 403587 records into the Access table, However, it freezes everytime I try to open up a query. I am trying to split the table into two. What is the fastest way to split the table into half? I am trying to select the records from 201794 all the way to the end, but it takes forever to select those record and paste to another table.
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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help.. Too much data !!
- Thread starter hkcaro129
- Start date
- Thread starter
- #3
How do I use append query?
I need to separate the table into two tables. If i perform the query on the second table, the accumlated balance for each of the transactions from the first table has to bring to the second table in order to get the accurate result.
Carol
I need to separate the table into two tables. If i perform the query on the second table, the accumlated balance for each of the transactions from the first table has to bring to the second table in order to get the accurate result.
Carol
This would be my approach. My instructions assume that the table is called "x", and that you have exactly 403,587 records in the monster table.
1) Rightclick x and choose "copy". Then rightclick the white space and choose "paste". Call the new table "z". The purpose of "z" is to provide a backup if the remainder of my plan fails.
2) View x in design view. Add an autonumber field called "index1" to x. Save your change.
3) Rightclick x and choose "copy". Then rightclick the white space qand choose "paste". Call the new table "y".
4) Create a new query without using the wizard. Use the "SQL view" option from the view menu. paste this code into the window:
DELETE x.index1
FROM x
WHERE (((x.index1)>201793));
Call the query "Q1"
5) Create another query using the same technique. Call it "Q2". Use this code:
DELETE y.index1
FROM y
WHERE (((y.index1)<201794));
6) Execute Q1 and Q2.
7) When you delete data it becomes invisible but it remains in the .mdb. This may degrade performance if you have many deleted records. Consequently, you may want to compact the database after completing these tasks. Choose "Tools/database utilities/compact and repair database". That will eject all of the garbage in the .mdb. Compacting may take hours if you have never done it previously.
1) Rightclick x and choose "copy". Then rightclick the white space and choose "paste". Call the new table "z". The purpose of "z" is to provide a backup if the remainder of my plan fails.
2) View x in design view. Add an autonumber field called "index1" to x. Save your change.
3) Rightclick x and choose "copy". Then rightclick the white space qand choose "paste". Call the new table "y".
4) Create a new query without using the wizard. Use the "SQL view" option from the view menu. paste this code into the window:
DELETE x.index1
FROM x
WHERE (((x.index1)>201793));
Call the query "Q1"
5) Create another query using the same technique. Call it "Q2". Use this code:
DELETE y.index1
FROM y
WHERE (((y.index1)<201794));
6) Execute Q1 and Q2.
7) When you delete data it becomes invisible but it remains in the .mdb. This may degrade performance if you have many deleted records. Consequently, you may want to compact the database after completing these tasks. Choose "Tools/database utilities/compact and repair database". That will eject all of the garbage in the .mdb. Compacting may take hours if you have never done it previously.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
