M
Malvaro
Here's the relevant info about my next project...
a) I have a 875mb+ stationary Access file which contains 2007-0
cust/prod info... its currently about 500k records/rows, maybe 50-6
fields/columns...
b) I also get bi-monthly Excel spreadsheets, generated by a 3rd part
program/database... the reports should always be under 1k rows, 2
columns... the file sizes should always be under 500kb...
I need to interact my Excel files with this Access database and pul
additional data into the Excel file... we'll make the assumption tha
the primary key tying the two reports together would be the produc
serial number...
Initially, I was thinking there is some type of VLOOKUP functionalit
that can be written into an Excel macro... but then thought there
probably some limitation to how many records/rows that Excel can acces
and process through...
then I thought about the opposite logic of somehow using an Acces
query to load the Excel spreadsheet and make the necessar
associations... but then how to spit out the final results back into a
Excel format? would the original Excel file somehow be able to b
utilized?
My Access knowledge is limited, but I can be a quick study... ca
someone throw me a bone as to what I should start reading up on... t
be able to get this thing done? even if its just a basic checklist o
how it might be done
a) I have a 875mb+ stationary Access file which contains 2007-0
cust/prod info... its currently about 500k records/rows, maybe 50-6
fields/columns...
b) I also get bi-monthly Excel spreadsheets, generated by a 3rd part
program/database... the reports should always be under 1k rows, 2
columns... the file sizes should always be under 500kb...
I need to interact my Excel files with this Access database and pul
additional data into the Excel file... we'll make the assumption tha
the primary key tying the two reports together would be the produc
serial number...
Initially, I was thinking there is some type of VLOOKUP functionalit
that can be written into an Excel macro... but then thought there
probably some limitation to how many records/rows that Excel can acces
and process through...
then I thought about the opposite logic of somehow using an Acces
query to load the Excel spreadsheet and make the necessar
associations... but then how to spit out the final results back into a
Excel format? would the original Excel file somehow be able to b
utilized?
My Access knowledge is limited, but I can be a quick study... ca
someone throw me a bone as to what I should start reading up on... t
be able to get this thing done? even if its just a basic checklist o
how it might be done