Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,175,272 members, 7,894,173 topics. Date: Friday, 19 July 2024 at 02:55 AM

Transfering Data's From Excel Into Mysql Database(php Guru's Please Help) - Webmasters - Nairaland

Nairaland Forum / Science/Technology / Webmasters / Transfering Data's From Excel Into Mysql Database(php Guru's Please Help) (729 Views)

Help With Transfering Domain Away From MTN Registrar / How To Upload An Image Into Mysql Database / How Do I Backup My Emails Before Transfering To A New Host (2) (3) (4)

(1) (Reply) (Go Down)

Transfering Data's From Excel Into Mysql Database(php Guru's Please Help) by ajaxphp7: 1:23pm On Oct 29, 2010
Assuming I have records up to 50,000 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.
Somebody should please help
Re: Transfering Data's From Excel Into Mysql Database(php Guru's Please Help) by Youngichou(m): 1:41pm On Oct 29, 2010
hmmmm i dont know on what method to use on this kind of implementation but i think you should use the import wizard
Re: Transfering Data's From Excel Into Mysql Database(php Guru's Please Help) by ajaxphp7: 1:48pm On Oct 29, 2010
Ok, Thanks I will try it
Re: Transfering Data's From Excel Into Mysql Database(php Guru's Please Help) by jaybee3(m): 1:48pm On Oct 29, 2010
Load the first spreadsheet into SQL database using the import wizard
Create a master table :
Select *
Into dbo.newtable (name of the project or whatever)
from dbo.firstspreadsheet

Every subsequent spreadsheet needs to be imported using the import wizard then a simple SQL

Select*
Into dbo.newmaster table
from dbo.newtable (name of the project or whatever)
union all
select*
from dbo.subsequent spreadsheet

Hope u get the gist sha.
Simple stuffs
Re: Transfering Data's From Excel Into Mysql Database(php Guru's Please Help) by Mobinga: 2:37pm On Oct 29, 2010
Transfering[b] Data's[/b] From Excel Into Mysql Database(php Guru's Please Help)

Datum - Singular
Data - Plural
wink

(1) (Reply)

What Does Spider/web Crawler Do To A Site / Web4africa Problems / Stubborn Virus.how Do I Get Rid Of Them?

(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. 7
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.