Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,180,927 members, 7,912,543 topics. Date: Tuesday, 06 August 2024 at 10:28 AM

Inserting Data In Excel Into Mysql Database - Webmasters - Nairaland

Nairaland Forum / Science/Technology / Webmasters / Inserting Data In Excel Into Mysql Database (1030 Views)

Inserting Adsense Into My Website / How To Upload An Image Into Mysql Database / How To Upload Mysql Database To Server (2) (3) (4)

(1) (Reply) (Go Down)

Inserting Data In Excel Into Mysql Database by ajaxphp7: 6:29pm On Oct 24, 2010
I really want to know if it is possible to insert a data in excel sheet into a MYsql Database.
And please what is the logic in getting it done.
Re: Inserting Data In Excel Into Mysql Database by LouisThoro: 6:34pm On Oct 24, 2010
Re: Inserting Data In Excel Into Mysql Database by Nobody: 9:44pm On Oct 24, 2010
What i know is Mysql has a tool that converts excel to sql, but your intention is an application that reads excel to sql my best bet is for you to look into COM under php where php application can access windows application or if it is possible create an ODBC DSN point to an excel file and connecting to that i think you should research more on this,
Re: Inserting Data In Excel Into Mysql Database by ajaxphp7: 1:20pm On Oct 29, 2010
Assuming I have Data' s up to 2000 records entered in excel and the company involve has been using excel to keep records for a long period of time, and now they need a system whereby those record can actually be transfered into MYSQL database.
What method can I actually use to implement this.
Re: Inserting Data In Excel Into Mysql Database by webaplanet(m): 1:06pm On Nov 21, 2010
use google to get this info, the tools are there or you pay someone to it for you, email mysticman2009@gmail.com
Re: Inserting Data In Excel Into Mysql Database by ajaxphp7: 2:28pm On Nov 24, 2010
I made a post on this trend so many contributed nicely and somebody is sending me a mail for me to pay money before he can render a help.
Wow, well great any way maybe he can become rich through the process.
any way no vess i go send u mail.
Re: Inserting Data In Excel Into Mysql Database by jaybee3(m): 2:32pm On Nov 24, 2010
Do you want an automated process or manual process?
Manual process is relatively easy:
Import the worksheet into a SQL table using the import wizard
Select x, y, z
Into dbo.new_table
From dbo.old_table
Union all
Select x, y, z
Into dbo.new_table
from dbo.old_table_1
group by x,y,z
order by 1,2,3

(1) (Reply)

Firefox 13 - Now Web Developers Can Be Really Happy / I Want Something Like Www.churchplus.com.ng / Problem Plz Help

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 8
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.