Database Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsOther TechnologiesDatabase Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
  #1  
Old August 11th, 2002, 07:49 PM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
 
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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.

Reply With Quote
  #2  
Old August 11th, 2002, 09:41 PM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
 
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
RE: Entering Data in a Table

It really depends on what database system you are using. Most provide a way to import from CSV....

Reply With Quote
  #3  
Old August 12th, 2002, 01:26 PM
EvilivE EvilivE is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Location: Milwaukee, WI USA
Posts: 291 EvilivE User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
Send a message via Yahoo to EvilivE
RE: Entering Data in a Table

Exactly, what rdbms are you using?

Reply With Quote
Reply

Viewing: Codewalkers ForumsOther TechnologiesDatabase Help > Entering Data in a Table


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT