| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL - Insert from Excel HELP!
Long shot: Add keyword values and swap out spaces in the path with
%20. Try: INSERT INTO rpt_NewLoanMonitor VALUES SELECT * FROM [DataSource] IN 'C: \Working%20Files\SQL_Scheduler.xls' 'Excel 8.0;' Even if the syntax is OK the statement won't work if the number of columns in rpt_NewLoanMonitor doesn't equal the number of columns in SQL_Scheduler.xls. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
| insert row / insert column command buttons | Excel Worksheet Functions | |||
| unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
| Macro to insert copy and insert formulas only to next blank row | Excel Programming | |||
| Insert cell/format/text/fontsize and auto insert into header? | Excel Programming | |||
![gimme_this_gimme_that@yahoo.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
