Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export Excel to SQL Server
Whats the best way to export data from an excel
spreadsheet that contains a Web Query to SQL Server (or any DB). How can I get the Web Query to Refresh before the export takes place(DTS or whatever) Any help on this would be great |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export Excel to SQL Server
"Tom Y" wrote in message
... Whats the best way to export data from an excel spreadsheet that contains a Web Query to SQL Server (or any DB). How can I get the Web Query to Refresh before the export takes place(DTS or whatever) Any help on this would be great My approach would be to set up an Access (.mdb) file containing linked tables to both the SQL Server table you are targeting as well as the spreadsheet containing the Web query. You can then define (using Accesss) an APPEND or UPDATE query that will do what you wish with the SQL server table. You can automate with Excel/VBA code by doing a QueryTable.Refresh for the web query then .Execute your stored APPEND or UPDATE query. -- Thomas Bartkus www.BartkusConsulting.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export Excel to SQL Server
Thanks for the help Thomas!
Where would I be doing the QueryTable.Refresh from? Where would this code be? Thanks -----Original Message----- "Tom Y" wrote in message ... Whats the best way to export data from an excel spreadsheet that contains a Web Query to SQL Server (or any DB). How can I get the Web Query to Refresh before the export takes place(DTS or whatever) Any help on this would be great My approach would be to set up an Access (.mdb) file containing linked tables to both the SQL Server table you are targeting as well as the spreadsheet containing the Web query. You can then define (using Accesss) an APPEND or UPDATE query that will do what you wish with the SQL server table. You can automate with Excel/VBA code by doing a QueryTable.Refresh for the web query then .Execute your stored APPEND or UPDATE query. -- Thomas Bartkus www.BartkusConsulting.com . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to export selected columns to SQL Server without programming? | Excel Discussion (Misc queries) | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Export from Access/SQL Server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) |