Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
VB code to import Excel sheet
0 views
Skip to first unread message
BobC
Dec 25, 2009, 11:50:03 PM12/25/09
to
I'm looking for the VB code to copy an Excel Sheet to an Access 2007
table. The sheet in is a know location.
I also want to clear the Access table prior to importing the Excel Sheet.
Thanks
table. The sheet in is a know location.
I also want to clear the Access table prior to importing the Excel Sheet.
Thanks
Douglas J. Steele
Dec 26, 2009, 8:23:26 AM12/26/09
to
Take a look at what Ken Snell has at
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"BobC" <Bob.Call...@cox.net> wrote in message
news:TBgZm.57278$ZF3....@newsfe13.iad...
0 new messages