Using VBA to transfer data from Excel to Access

[SteveCarrier]

I was wondering if anyone knew a good place to look where to get info about transferring data from Excel to Access in VBA code. Referencing different cells and taking the info and inserting it into some Access tables.

Thanks in advance.

Steve Carrier

 

[khood]

steve,

"The Access Web" has an excellent mix of access/office examples:

http://www.mvps.org/access/modules/mdl0006.htm

Good luck,
K.Hood

 

[jebry]

Hi Steve!

You can like to an Excel worksheet and use it in Access just as if it were a table.

hth
Jeff Bridgham
bridgham@purdue.edu