var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Pulling Specific Data from Excel
I have a database that needs to pull data from Excel.
Specifically, one specific Access field should go directly to a specific
cell in Excel and get that value.
I'm thinking that I use some kind of VBA code to open my
Excel file and assign the cell contents to a variable
which I then use in Access. I think I can find the cell
in Excel using a named range.
I need the exact code, though.
How do I do this?
The technique you're looking for is called automation. Here are the basics:
ACC2000: Using Automation to Transfer Data to Microsoft Excel
Need to do the reverse....from Excel to Access
Originally Posted by pbaldy
So, reverse this:
mysheet.cells(1, 1).Value = myfield