Concatenate Excel spreadsheets in Access?
Concatenate Excel spreadsheets in Access?
(OP)
I recieve 30+ spreadsheets everyday in Excel format. I am looking to find a way to add a set of rows together from all of the spreadsheets. Once I have them all together, I need to be able to sort by different fields to create reports. Does Anyone have any ideas?





RE: Concatenate Excel spreadsheets in Access?
TTFN
RE: Concatenate Excel spreadsheets in Access?
RE: Concatenate Excel spreadsheets in Access?
TTFN
RE: Concatenate Excel spreadsheets in Access?
CODE
myFile = Dir("c:\myDirectory\*.xls")
Do While Len(myFile) > 0
MsgBox myFile ' or process here
myFile = Dir
Loop
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: Concatenate Excel spreadsheets in Access?
Then create a query that joins them all together
eg
Select * from Sheet1
Union All
Select * from Sheet2
Union All
Select * from Sheet3
Result - a read only query that shows all records in all the sheets
That can be sorted any way you like in another query.