is it possible to import say 10 excel files into DB at once?
like in PhpMyAdmin, I go and import each file one by one and they are added as new tables.
is there some kind of php code I can write to take all files in X folder and import them? without selecting them one at a time.
54uydf
1
Junior Poster
Recommended Answers
Jump to PostYou can't import them at once.
What is the structure of your files?
Your data must be stored at one DATABASE and at one table? or at one database in 10tables I didn't understand you about that.
Jump to PostTry this:
Create database.
Click on this database at your phpmyadmin.
Then click at the Import (after you have selected the database) and import.
It should create each new table at this database.
Jump to PostExcel export files are .csv?
If yes, you can use fgetcsv() php function (erelsgl at gmail dot com 09-May-2011 12:57 post example).
Jump to Postperhaps I could help but would need a sample xls file, I have only worked with csv's to do what you want. It would only have to be 3 or 4 rows long with the header fields and some garbage data. Is it possible to create the xls files as …
All 14 Replies
sv3tli0
0
Junior Poster in Training
54uydf
1
Junior Poster
sv3tli0
0
Junior Poster in Training
54uydf
1
Junior Poster
eXpertPHP
0
Newbie Poster
54uydf
1
Junior Poster
54uydf
1
Junior Poster
diafol
sv3tli0
0
Junior Poster in Training
ddymacek
15
Posting Whiz
54uydf
commented:
can't thank you enough!!
+3
54uydf
1
Junior Poster
54uydf
1
Junior Poster
diafol
54uydf
1
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.