Exporting specific cells then import to access

L

Lordzion

I have a folder of about 500 excel files. I dont care how many steps it
takes to have this done. BUT is it possible to export specific cells
out of excel and then import them into access. For example

cell b5 = $##,### in all my excel documents. I need to export that
specific number in that specific cell.

Then I need to insert just those numbers into a table in access.

Thanks for the help in advance,

Matt
 
A

arthurjr07

is it possible to export specific cells
out of excel and then import them into access
Click to expand...

Yes, it is possible.You have to loop on all excel files
in that folder, open it one by one, get the value of cell b5
and insert it to access table.

if i were you, i will program it in Ms Access.
 
Top