Exporting Data from an open Excel Worksheet to SQLServer

[Paul O. Schenker]

Hi all,

could someone tell me how this would have to be coded in VBA:
I want to export a range (named range) of data on an active Excel sheet to
my SQLServer without having to close my workbook.

Thanks for any hint.

Paul

 

[Cindy M -WordMVP-]

Hi Paul,

could someone tell me how this would have to be coded in VBA:
I want to export a range (named range) of data on an active Excel sheet to
my SQLServer without having to close my workbook.

(Finally saw your follow-up post) Is your problem then extracting the data
from the Excel range? I'd ask this in the excel.programming newsgroup, where
you'll find many more Excel-savvy folks than here... I'm not sure that there's
a way to "dump" an entire range into a recordset, or whether you'd need to
"walk" the cells in the range.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail