Slick, I have a friend who is a database wizard, I'm sure he has a solution to this - if it is possible. Only, it's late here, so I can't contact him until tomorrow.
Goodnight!
Registered User
Slick, I have a friend who is a database wizard, I'm sure he has a solution to this - if it is possible. Only, it's late here, so I can't contact him until tomorrow.
Goodnight!
"I don't know which weapons will be used in the third World war, but in the fourth, it will be sticks and stones" --- Albert Einstein.
Registered User
Slick, this is what my friend said:
Do an auto increment with all records, then do a view, sort view by increment, in there, write select top 65.535 (that’s how many records it can take in one go) Then delete those records from Access (make a back-up first), then take the next 65.535. They will go in the next Excel sheet, then just continue to export and delete from view until you have them all.
Hope this helps!
"I don't know which weapons will be used in the third World war, but in the fourth, it will be sticks and stones" --- Albert Einstein.
THE HOUSE OF ORANGE
Well goodness, you lost me Slick, with "calling all experts"
Randi, how great you were able to get her an answer so quickly!
)))AMERICA BLESS GOD(((
Ummmm, thats all greek to me..
I'm Canadian......eh?
Thanks Randi. That was a great help. I love it when you talk "tech"...
Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body, but rather to skid in sideways, champagne in one hand and strawberries in the other, body thoroughly used up, totally worn out, and screaming WOO HOO - What a Ride!
--unknown
Sometimes the most real things in the world are the things we can't see
--Polar Express
Until one has loved an animal, part of their soul remains unawakened.
Posting Permissions
Copyright © 2001-2013 Pet of the Day.com
Reply With Quote
Bookmarks