Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Appending excel worksheets
I have a huge number of comma delimited excel worksheets and need to copy or
append them into a single worksheet. There are over 7000 records on some 300 worksheets, so doing a manual copy and paste would take a lot of time. If I cannot do that in Excel, is there a way to do this in Access and create a database? |
#2
|
|||
|
|||
Actually, if you have Access, the quickest way would be to import all of your Excel data into a single Access table then (if
necessary) re-export it to an Excel file. Set up and save your import settings, then repeat for all worksheets/files... then use Excel's Get External Data to bring it back into one sheet. Other solutions would include writing a VBA procedure to grab all the data; this would work best if all of your sheets are in one file or if all of your filenames are similar. "Rbuzard" wrote in message ... I have a huge number of comma delimited excel worksheets and need to copy or append them into a single worksheet. There are over 7000 records on some 300 worksheets, so doing a manual copy and paste would take a lot of time. If I cannot do that in Excel, is there a way to do this in Access and create a database? |
#3
|
|||
|
|||
"JPW" wrote: Actually, if you have Access, the quickest way would be to import all of your Excel data into a single Access table then (if necessary) re-export it to an Excel file. Set up and save your import settings, then repeat for all worksheets/files... then use Excel's Get External Data to bring it back into one sheet. Other solutions would include writing a VBA procedure to grab all the data; this would work best if all of your sheets are in one file or if all of your filenames are similar. "Rbuzard" wrote in message ... I have a huge number of comma delimited excel worksheets and need to copy or append them into a single worksheet. There are over 7000 records on some 300 worksheets, so doing a manual copy and paste would take a lot of time. If I cannot do that in Excel, is there a way to do this in Access and create a database? |
#4
|
|||
|
|||
Even simpler - use the DOS copy command - if you specify multiple "from
files" and a single "to" file they will automatically be appended. "JPW" wrote: Actually, if you have Access, the quickest way would be to import all of your Excel data into a single Access table then (if necessary) re-export it to an Excel file. Set up and save your import settings, then repeat for all worksheets/files... then use Excel's Get External Data to bring it back into one sheet. Other solutions would include writing a VBA procedure to grab all the data; this would work best if all of your sheets are in one file or if all of your filenames are similar. "Rbuzard" wrote in message ... I have a huge number of comma delimited excel worksheets and need to copy or append them into a single worksheet. There are over 7000 records on some 300 worksheets, so doing a manual copy and paste would take a lot of time. If I cannot do that in Excel, is there a way to do this in Access and create a database? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How to send Excel 2000 worksheets to Excel 2003? | Excel Discussion (Misc queries) | |||
Slow opening Excel Workbook with over 50 Worksheets | Excel Discussion (Misc queries) | |||
MS Excel Worksheets | Excel Discussion (Misc queries) |