Stacking Tables

[daylilies]

Hi, I have a database with tables that are linked to spreadsheets. These spreadsheets all have the same fields but are seperated by beginning initial of last name. For example two of the spreadsheet names are Emp A-c.xls and Emp D-G.xls. I need the database to use these (linked) spreadsheets and create one table from all the spreadsheets without having to use import or export, copy and paste.

Does anybody know how to program a query, a macro or any other way within Access to get it to do this.

Thanks in Advance for all your help
- Erica

 

[downwitchyobadself]

Use a UNION query to put together all the linked spreadsheets. Search Access help for union query to learn how they work; it's basically

one SQL statement
UNION second SQL statement
UNION third SQL statement

fairly straightforward, but it is SQL only.

 

[B827]

UNION queries should do it but you may need

UNION ALL

you may lose data otherwise (if there are a number of 'John Smith' with no way of distinguishing between them)

 

[daylilies]

THANK YOU BOTH> THIS WORKED PERFECT!!!