I have about 100 invoices stored in different worksheets in the same
workbook. The invoices have the same format in terms of data location, but
contain different information. (they were created over time by copying the
same invoice and changing its information)
Is there any way to convert these invoices into an access database in a mass
production method?
What will happen to the formulas used to calculate the line totals and the
invoice totals?

Easiest method would probably be to automate gathering all of the data from
the different sheets into a single sheet (assuming you can get it all within
the 64K rows on a single sheet) and then import that sheet's data into an
Access table. Only data/values will be imported. You'll then want to
examine the table, which will have one field for each column imported, and
determine which fields were calculated, toss them out and start setting up
your database to use its own versions of the formulas to do the totals and
such.

There are several approaches to a solution, but without knowing more about
your invoice layouts and such, it's difficult to say more. You could
actually use code to move data from individual invoices into Access data
tables. Since your invoice data is probably laid out in some neat looking
format, you'd either need to do it that way, or use some way of getting
needed information from each invoice into rows of data initially you'd have
lots of repeated information in some columns, but that would be dealt with
once it's moved into Access: breaking the imported data out into several
related tables to improve performance and efficiency.

"Karim" wrote:

I have about 100 invoices stored in different worksheets in the same
workbook. The invoices have the same format in terms of data location, but
contain different information. (they were created over time by copying the
same invoice and changing its information)
Is there any way to convert these invoices into an access database in a mass
production method?
What will happen to the formulas used to calculate the line totals and the
invoice totals?