Query to separate a table containing many sub tables

[Darren Tecklenberg]

I have a table containing 885,000 records with 116 sub table identifyers, but
without a field that can uniquely identify each of the sub tables. When I
import the data for this table I have a key field auto generated to uniquely
identify each record as identified below:-

Key Field 1 Field 2 Field 3
1 Table SITES
2 Fields SYS_REF SITENAME REGION
3 1 Site 1 North
4 1 Site 2 North
5 1 Site 3 South
6 Table PRODUCTS
7 Fields ITEM_REF ITEMTYPE ITEM NAME
8 000001 0001 TEA ENGLISH
BREAKFAST
9 000002 0002 COFFEE BEANS
10 000003 0001 TEA EARL GREY
etc...etc...etc...

What I want to do though is to create a query that pulls out each table
separately so that I can then run some more complex queries, alternatively be
able to import teh data and have it separate the tables out separately by
locating the Field 1 entries beginning with "Table *"

 

[Peter Hibbs]

Darren,

Not sure if this will help but have a look at the Excel to Access
Converter Utility program at :-

http://www.rogersaccesslibrary.com/...me='Excel to Access Converter Utility program'

which may be able to do what you want.

Peter Hibbs.