By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,359 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,359 IT Pros & Developers. It's quick & easy.

Importing an Excel Spreadsheet in Access 2007 using VBA

P: 1
I need help importing an excel spreadsheet into an existing access table using vba. However I have a few requirements.
1. It needs to prompt the user to specify where the spreadsheet is
2. It needs to import into an existing table.
Jun 8 '07 #1
Share this Question
Share on Google+
2 Replies

ADezii
Expert 5K+
P: 8,750
I need help importing an excel spreadsheet into an existing access table using vba. However I have a few requirements.
1. It needs to prompt the user to specify where the spreadsheet is
2. It needs to import into an existing table.
  1. You can use a File Open Dialog Box to allow the User to Browse for a Spreadsheet to Import.
  2. You can define the Table to Import to as a Constant in the code and use it within the TransferSpreadsheet Method.
  3. Is this what you are looking for?
Jun 9 '07 #2

P: 7
I need help importing an excel spreadsheet into an existing access table using vba. However I have a few requirements.
1. It needs to prompt the user to specify where the spreadsheet is
2. It needs to import into an existing table.
ok
1.use a commondialog control showopen method to retrieve the spreadsheet choice
save the user chioice and use it in . . .
2. the transferspreadsheet method to import the data
Jun 9 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.