Mark
|
| Posted: 02/26/2002, 2:23 PM |
|
Hi,
Newbie question -
I'm proposing to develop a db driven site using PHP/MySQL in CodeCharge.
Once I've set up the tables in the database, how do I load the data ?
In this case Im probably looking at uploading details for around 1,000
products, storing the data by Category & sub-category.
If I can get everything into a spreadsheet, is there an 'easy' way to load
the db ?
Is going the spreadsheet route the right way ?
I realise that this is not strictly a CC request, but any help much
appreciated !
Thanks,
Mark
|
|
|
 |
Tomasz Golebiowski
|
| Posted: 02/26/2002, 10:27 PM |
|
use free soft: phpmysql (installed on server,usually by your ISP) or MYSQL-Front
(windows) to upload text file to mysql. You can specify any field separation
char.
"Mark" <mark@markate.demon.co.uk> wrote in message
news:a5h1th$m4v$1@news.codecharge.com...
> Hi,
>
> Newbie question -
>
> I'm proposing to develop a db driven site using PHP/MySQL in CodeCharge.
>
> Once I've set up the tables in the database, how do I load the data ?
>
> In this case Im probably looking at uploading details for around 1,000
> products, storing the data by Category & sub-category.
>
> If I can get everything into a spreadsheet, is there an 'easy' way to load
> the db ?
> Is going the spreadsheet route the right way ?
>
> I realise that this is not strictly a CC request, but any help much
> appreciated !
>
> Thanks,
> Mark
>
>
|
|
|
|
Chris Seymour
|
| Posted: 02/27/2002, 7:37 AM |
|
Hi Mark,
If you can get the file into a spreadsheet, what I usually do is this:
In a column next to my first data row I create a formula like this (I use
Excel) ="insert into mytable(filed1,...) values("+A1+","+A2...)"
Then I copy that formula to the remaining rows and cut and paste into
Notepad.
I now have a series of insert statements that I use to add to my data.
If you want contact me offline and we can get you going.
Cheers.
Chris
|
|
|
|
Mark
|
| Posted: 03/03/2002, 8:36 AM |
|
Hi
thanks for the info.
I'll give it a try & let you know if I get stuck (probably !)
Cheers,
Mark
Chris Seymour <cseymour@seyware.com> wrote in message
news:91C26400Ecseymourseywarecom@66.180.229.147...
> Hi Mark,
> If you can get the file into a spreadsheet, what I usually do is this:
> In a column next to my first data row I create a formula like this (I use
> Excel) ="insert into mytable(filed1,...) values("+A1+","+A2...)"
>
> Then I copy that formula to the remaining rows and cut and paste into
> Notepad.
>
> I now have a series of insert statements that I use to add to my data.
>
> If you want contact me offline and we can get you going.
>
> Cheers.
>
> Chris
|
|
|
|
Steven Dowd
|
| Posted: 03/05/2002, 6:38 PM |
|
I think you would find this lots easier if you just downloaded and installed
dbtools, which can handle transfer of data from excell, or access databases
directly to and from mysql.
http://www.dbtools.com.br/
Steven
"Mark" <mark@markate.demon.co.uk> wrote in message
news:a5tjer$r51$1@news.codecharge.com...
> Hi
>
> thanks for the info.
> I'll give it a try & let you know if I get stuck (probably !)
>
> Cheers,
> Mark
>
> Chris Seymour <cseymour@seyware.com> wrote in message
>news:91C26400Ecseymourseywarecom@66.180.229.147...
> > Hi Mark,
> > If you can get the file into a spreadsheet, what I usually do is this:
> > In a column next to my first data row I create a formula like this (I use
> > Excel) ="insert into mytable(filed1,...) values("+A1+","+A2...)"
> >
> > Then I copy that formula to the remaining rows and cut and paste into
> > Notepad.
> >
> > I now have a series of insert statements that I use to add to my data.
> >
> > If you want contact me offline and we can get you going.
> >
> > Cheers.
> >
> > Chris
>
>
|
|
|
|
|
