Import (copy) Data into One Big Table > Then Spit into Multiple Ta

C

Curtis Stevens

I have an onoline application and it sends me all the data in tab delimited
format. I need to have one big table where I paste that info into. It has
been advised to have more than one big table, so how do I append or move that
one record to the other multiple tables? I know you can do it with an append
query, but don't you have to have a query for each table? So if I have it
split up into 5 tables, you are looking at having to run 5 queries each time
I want to insert one new application....

Thanks
Curtis
 
Top