I a little direction in starting my project (1 Viewer)

In response to post 19, you say to import the data to a table in access CJ but should I put it in one table as there will be data from about 7 spreadsheets, each spreadsheet has 12 sheets for the months of the year and each sheet would have anywhere between approximately 100-400 lines. Would this be too much for a single table in access to handle?

Would this be too much for a single table in access to handle?

Click to expand...

No, depends on how many columns but I have db's with millions of records. You are talking about 30,000 which is not much at all.

If you need to know which workbook and/or which worksheet a record came from then make sure you include columns for these as well as the data