Newbie needs help with Macro to link Excel Workbooks

[sunshine]

Hi All

I have looked through the past postings and found some replies to my question but since I am a very new user to Access, many of them seem like a different language!

I have a workbook with 8 worksheets. I would like to be able to link at least 3 of them. I will redo the worksheet if necssary.

I don't know much about coding etc but I'm willing to try! So far I have used a macro to transfer worksheet but it always gives me the wrong sheet.

Can anyone point me in the right direction?

Thanks!
Sunshine

 

[Parra]

Are you trying to import the data from your spreadsheets into an Access Table????

If yes this is simple. But before I continue please clarify a bit what do you want to do.

Parra

 

[sunshine]

Hi Parra;

My Excel spreadsheet consists of customer info, invoice, and payment info. Because it is easier to use Excel Formulas, I want to be able to add data and do the calculations in Excel while having the same data in Access updated.

Thanks for any help.
Sunshine

 

[Parra]

Hi Sunshine

You can create a form, that does the calculations for you in the same way the excel spreadsheet does.

The way I would go about it is to create the tables, then a query here is where you would do the calculations. Then create a form off your query.

Do you still want to import it from Excel?

It would not be complicated, just tedious.