Importing info from Excel

[Shannon]

I have a very complicated form created in Excel that I want to import the information into Acces after they are done inputting. Does anyone have any ideas?

 

[jwindon]

Here's an idea....haven't really tried it much. I'm guessing that your "form" in excel is not in spreadsheet format.?!?

Anyway, I remember trying something similar. What I did was create another sheet in my workbook and created links to the pertinent cells in the "form". Then I had Access import the values of the linked sheet which was in spreadsheet format.

Just a thought.

You might also want to consider using access for your form input?!? You can run reports as well as EXPORT the data back to Excel to perform any calculations that you you need.

 

[Shannon]

Thanks, but I decided to recreate the whole form. It was more work but this way I don't have to worry about if the data valid or not.