|
|
#1
07-02-2012, 07:28 AM
|
|||
|
|||
Easy send/save Excel data to Database Table or Stored Procedure
Is there an easy way to save/upload Excel data to Database Table or Stored Procedure?
(preferably without any code!) (also posted here http://www.ozgrid.com/forum/showthread.php?t=167132) Last edited by TonyHarvard; 07-02-2012 at 03:09 PM. Reason: link to other post 
|
|
#2
07-03-2012, 04:20 AM
|
||||
|
||||
|
If your database can read CSV files, and your Excel data are suitably structured, you could save the workbook in the CSV format.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
#3
07-03-2012, 04:36 AM
|
|||
|
|||
|
App
Quote:
I found an excel app via google that validates and uploads data, looks like what I want, so giving that a try.. FYI : http://leansoftware.net Cheers, Tony Last edited by TonyHarvard; 07-04-2012 at 02:57 AM. Reason: url fyi
|
|
#4
07-11-2012, 12:43 PM
|
|||
|
|||
|
excel to database tool
It does not support 64 bit office yet though but I can see there is a new version planned.
Pretty neat for validating and sending/updating data I thought. Has anyone else looked at this tool?
|
|
| Tags |
| excel save to database, excel to table, upload excel to database |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linking excel table to powerpoint for easy update | atwood121 | PowerPoint | 0 | 05-11-2012 07:09 AM |
| excel where is procedure being called from | davids67 | Excel Programming | 1 | 11-18-2011 06:48 AM |
 How do I dynamically update data in a Word Document from a database table
|
RSchmidt | Word | 1 | 07-14-2011 04:27 PM |
| Using data entered in prompt to search database table | BluRay | Word | 1 | 03-25-2011 01:47 AM |
| Sub Procedure for File Save As PDF or XPS menu option | gsbakshi | Word VBA | 0 | 02-19-2010 12:22 AM |
Windows 7 64bit 
Office 2010 32bit
Linear Mode
