By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,786 Members | 1,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,786 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,770
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.