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

Data From Excel File without import into Access

P: 41
Hi,

Can anybody suggest me how to take data from an Excel file without import into Access as a Table..?

Bcoz...I hve several file. if i import, it would take more time and increase the file size..

My purpose can explain by below example..

In a Excel file, Assume that Name,Std,Mark1,Mark2,Mark3,etc., are coloumn header, and under this coloumns header, necessary data are filled.

Now, I need to get ONLY Mark3 detail for selected Name.

Believe its clear..

Is there anyway to do like this...?

Your suggestion would be greatly appreciated.

Thanks in advance.

ngr.
May 17 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi,

Can anybody suggest me how to take data from an Excel file without import into Access as a Table..?

Bcoz...I hve several file. if i import, it would take more time and increase the file size..

My purpose can explain by below example..

In a Excel file, Assume that Name,Std,Mark1,Mark2,Mark3,etc., are coloumn header, and under this coloumns header, necessary data are filled.

Now, I need to get ONLY Mark3 detail for selected Name.

Believe its clear..

Is there anyway to do like this...?

Your suggestion would be greatly appreciated.

Thanks in advance.

ngr.
Have a look at the following tutorial regarding automation. Is this the kind of thing you're looking for.

Application Automation
May 22 '07 #2

NeoPa
Expert Mod 15k+
P: 31,441
Alternatively for Excel, you can Link tables into a range in a workbook.
Jun 2 '07 #3

Post your reply

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