Importing Data into a sql table.

[tradeinthailand]

Hi all,

 

I have a script on my server that uses a sql file. I wish to import some data into one of the tables. The data is in an excel spread sheet. there are around 160 records consisting of first name, last name and email address.

 

My server is running phpMyAdmin 2.5.4

MySQL 4.0.16-standard

 

Here is a dump of the table (currently there is no data in the table.

 

# phpMyAdmin SQL Dump

# version 2.5.4

# http://www.phpmyadmin.net

#

# Host: localhost

# Generation Time: Jun 14, 2008 at 11:48 AM

# Server version: 4.0.16

# PHP Version: 4.4.4

#

# Database : `teflclass_news`

#

 

# --------------------------------------------------------

 

#

# Table structure for table `InfResp_subscribers`

#

 

CREATE TABLE `InfResp_subscribers` (

  `SubscriberID` bigint(32) NOT NULL auto_increment,

  `ResponderID` bigint(32) NOT NULL default '0',

  `SentMsgs` text,

  `EmailAddress` varchar(100) NOT NULL default '',

  `TimeJoined` bigint(32) NOT NULL default '0',

  `Real_TimeJoined` bigint(32) NOT NULL default '0',

  `CanReceiveHTML` tinyint(1) NOT NULL default '0',

  `LastActivity` bigint(32) NOT NULL default '0',

  `FirstName` varchar(255) NOT NULL default '',

  `LastName` varchar(255) NOT NULL default '',

  `IP_Addy` varchar(255) NOT NULL default '',

  `ReferralSource` varchar(255) NOT NULL default '',

  `UniqueCode` varchar(255) NOT NULL default '',

  `Confirmed` tinyint(1) NOT NULL default '0',

  PRIMARY KEY  (`SubscriberID`)

) TYPE=InnoDB AUTO_INCREMENT=442 ;

 

I wish to just import the  following fields

 

`ResponderID`  value 1

`EmailAddress`  from the excel file

`FirstName`      from the excel file

`LastName`      from the excel file

`Confirmed`      value 1

 

I can't see anyplace on the phpMyadmin to import data.

 

I would be grateful for any help. If you need more info to help me please just ask.

 

Thanks in advance,

 

Chris R

[bagpiperdude90]

 

Arrows show how to import excel data - just save the excel file as CSV.

 

But you're trying to merge the two together?

 

Maybe create a temp table, upload SQL file, delete the excess from it, then upload the excel file? Dunno if it would work... just an idea

[tradeinthailand]

Hi bagpiperdude90,

 

Thanks for the reply. I do not have an 'import' tab on my version of phpMy admin.

 

I have a tab for exporting but there is nothing about importing.

 

Chris R