Hit another wall...researched the World, but didn't find what I could get to work. I have an Excel 2007 spreadsheet with cells 'D4', 'I2' & 'N4', set as
type 'text'. I have a table with fields named: 'Area', 'Cust_No' & 'L_Name'.
I want to read the excel data into the table when I push a button. If somebody can show me the vba to do that for one xlsx file, I think I'll be able to expand the sub-routine to loop through additional xlsx files and do the transferring to the table.
type 'text'. I have a table with fields named: 'Area', 'Cust_No' & 'L_Name'.
I want to read the excel data into the table when I push a button. If somebody can show me the vba to do that for one xlsx file, I think I'll be able to expand the sub-routine to loop through additional xlsx files and do the transferring to the table.