Error Import Command Button

[kowen091010]

Name: Form1
Drive Location:J:\BYY Goal 7 - 2011
Excel File Name: Current Customers


Excel File Type: Macro-Enabled Worksheet
Table 1 - tblaggregateddata - need to add to table
Table 2 - Current Customers - need to replace all information in this table with imported data.
Command Button - Command6 & Command8

I have been trying to write the proper code to get these to buttons to automatically import the data. Unfortunately everything I have tried has failed. Above are the names from my Access Database and Computer Drive. Could someone please help me write the proper code or figure out a macro in order to add a Command Button?

Please and Thank you!!!

[alansidman]

Here is a sample of what you are trying to do. Look at the VBA code behind the command buttons. Note that this was created to work in an WIN XP operating system, so the paths to and from the excel worksheets will have to be amended, but you should see the overall methodology and should be able to adapt it to your environment.

[kowen091010]

Please see attached. I should tell you I am a beginner at Access and my work would like me to be an expert. I appreciate your help!

[alansidman]

What error are you getting?

In the Docmd line, remove the parenthesis from the path for a starter.

[kowen091010]

Set wb = appExcel.Workbooks.Open(H:\CurrentCustomer.xls) Error - Expected list serperater.