Hi,
I am new to using Excel VBA to import into SQL Server 2008.
Currently I have 17 files to upload up to 1000 rows manually. Is there a VBA that can load an excel file directly into SQL?
It would be faster then loading 1 file at time in SQL import.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
> </o
>
I was thinking having named range and having SharePoint addresses of xlsm /xlsx files and looping it through.
<o
> </o
>
Any suggestions would be greatly appreciated.
Biz
I am new to using Excel VBA to import into SQL Server 2008.
Currently I have 17 files to upload up to 1000 rows manually. Is there a VBA that can load an excel file directly into SQL?
It would be faster then loading 1 file at time in SQL import.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




I was thinking having named range and having SharePoint addresses of xlsm /xlsx files and looping it through.
<o


Any suggestions would be greatly appreciated.
Biz