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

Import Specific Excel cells into an Access database

P: 10
We are about to receive 500 excel spreadsheets from a client. The data has not been arranged in tabular form. Is it possible to import specific cells, say J10, M10, J15, M22 into an Access table using SQL or whatever? I saw a reply somewhere that indicated you had to create name ranges in excel and then import the range but that seems like a lot of work considering I'm dealing with 500 workbooks with up 8 specific worksheets in each. I'd love to be able to select specific cells from a specific spreadsheet and update an Access table.
Jul 16 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 634
Hi
We are about to receive 500 excel spreadsheets from a client. The data has not been arranged in tabular form. Is it possible to import specific cells, say J10, M10, J15, M22 into an Access table using SQL or whatever? I saw a reply somewhere that indicated you had to create name ranges in excel and then import the range but that seems like a lot of work considering I'm dealing with 500 workbooks with up 8 specific worksheets in each. I'd love to be able to select specific cells from a specific spreadsheet and update an Access table.
The short answer is yes you can do what you like. How you do it depens on what you are doing and in what programme you doing it.

You can do it in Access using automation to start Excel, open the files(s) and update tables/fields with specific Cell data, or (as is my prefered method) you can run code on Excel to open the file(s) and update the Access tables using an ADO connection and/or recordsets.

I find using range names does have an advantage, but this is only practical if you define the speadsheet used youself (ie timesheets or similar), but if the spreadsheets ar received form a third party or generated from other data sources/databases then this is not practicale and would need the data to be in a standardised format.

It depends on which application you are familiar with and your level of VBA experiance.

I think that answers the question, but does it provide a solution?


MTB
Jul 17 '07 #2

P: 10
Thanks, I'd like to use Access as my excel micro skills are very rusty. Can you give me an example of how to code Access to pick the cells I want?
Jul 17 '07 #3

Post your reply

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