Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search within JDBC and Relational Databases
Search Coderanch
Advance search
Google search
Register / Login
Post Reply
Bookmark Topic
Watch Topic
New Topic
programming forums
Java
Mobile
Certification
Databases
Caching
Books
Engineering
Micro Controllers
OS
Languages
Paradigms
IDEs
Build Tools
Frameworks
Application Servers
Open Source
This Site
Careers
Other
Pie Elite
all forums
this forum made possible by our volunteer staff, including ...
Marshals:
Campbell Ritchie
Tim Cooke
paul wheaton
Ron McLeod
Jeanne Boyarsky
Sheriffs:
Paul Clapham
Saloon Keepers:
Tim Holloway
Roland Mueller
Bartenders:
Forum:
JDBC and Relational Databases
update sql database using excel spreadsheet records
Legape McCarthy
Greenhorn
Posts: 2
posted 13 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
i have recently recieved an updated spreadsheet for students data. is the anyhow i can update my database table using records from excel. updating them manually will take a long time as they are many records. your help will be appreciated. Thanks
Sridhar Santhanakrishnan
Ranch Hand
Posts: 317
posted 13 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Off the top of my head, you can probably concatenate the columns into a separate column in the spreadsheet to be something like
update <tablename> set A=$A1, B=$B1...... where Z=$Z1
using excel formulas and then copy the whole column onto your SQL Editor and run it once.
It's just a flesh wound! Or a tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
reply
Bookmark Topic
Watch Topic
New Topic
Boost this thread!
Similar Threads
xls file
Copy excel file to access table
difference between two dates with excel as database
How much data can a session bean hold?
Java with Excel 2007
More...