
August 11th, 2002, 07:49 PM
|
|
Registered User
|
|
Join Date: Apr 2007
Posts: 22,309
Time spent in forums: < 1 sec
Reputation Power: 24
|
|
|
Entering Data in a Table
I have to install a Mailing List on my Host server, and am considering one or two that use a Sql database.
One of them is split into various tables containing different information, the one that stores the e-mail addresses having only 3 fields - ID, Name, E-mail address.
My problem is that I have to populate this table with over 2000 customer/prospect e-mail addresses which are currently held in an Excel Spreadsheet on my local machine.
Does anyone know of a script which can be used to populate an existing Sql table 9on a server)with data from an Excel or CSV file (on a local machine).
I found one script that supposedly does this, but I get errors and there are no Install or Configure notes with the script, and the author has not responded to my e-mails asking for guidelines.
An alternative would be a script that uses a file stored on the server, 'cos I could always upload it before running the script.
Any help would be appreciated.
|