Please help ... urgent...Access table split..

[bengalliboy]

I am trying to export Access records using odbc and it works fine w small table.... but with a table of 100k it just hangs. How can I split an Access table, using VBA code and dynamically create splitted tables? Please help on this.. TIA for any suggestion...

 

[jgoodman00]

I believe there is actually a table splitting wizard which may well help you.
Tools-Analyze-Table James Goodman
j.goodman00@btinternet.com

 

[bengalliboy]

Thanks, I need some sample code since I am using VBA... Please help@@