If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I initially had some great help establishing tables for my database but I forgot what forum and the person that was so helpful. Sometimes, age has its rewards and sometimes age...um...what was I saying?
Now I am attempting to figure out how to populate the tables with data from Excel. I have read I can import and or link excel sheets but this seems to store them in the DB (correct me if Im wrong).
What I think I am facing is reading from an excel sheet and pupulating tables via VBA, Im pretty good with VBA just need to learn Access VBA commands.
Any help, hints, tips or examples is appreciated.
Attached is my DB and a sample excel file. There are no macros in either.
__________________
Regards
Rick
NT 4.0, Office 2000
(aka Rick S.)
Last edited by Rick_Stanich; 06-04-2009 at 05:04 PM.
__________________
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the scales and adding to my reputation, Thanks!
Could be because I used WinRAR and renamed to ZIP.
Here is another copy. The file is actually a RAR file, if you have trouble viewing or extracting change the extension to RAR.
Linear Mode
