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

Access Vs Excel

P: 1
I want to get data form the Excel sheet into my database developed in the Access. How i can do this? Plz help me.
thanks u all
Aug 6 '07 #1
Share this Question
Share on Google+
2 Replies


P: 48
I want to get data form the Excel sheet into my database developed in the Access. How i can do this? Plz help me.
thanks u all
Easiest way is with the "Get External Data" tab in Access.

File-->External Data-->Import

Another handy way is to build a predefined macro. Goto Macros --> New Macro --> and choose the Variable TransferSpreadsheet

Hope I could help you.
Aug 6 '07 #2

P: 65
You can do this from VBA code to

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "THE TABEL YOU WANT TO IMPORT IN", "THE FILE YOU WANT TO IMPORT", True
Aug 6 '07 #3

Post your reply

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