Skip to main content
M
Mardenweb
Known Participant
November 28, 2008
Question

Import CVS file to Mysql

  • November 28, 2008
  • 2 replies
  • 966 views
Hi,
I am trying to import a database from excel into mysql on myphpadmin. I create the database name and the table and then to go import at top and locate the cvs file, but I get a error every time #1064 error. How do you get the information from the data in excel into the table?

Thanks for any help you can provide.

Dennis
This topic has been closed for replies.

2 replies

N
Newsgroup_User
Inspiring
November 28, 2008
CSV? 8)

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"David Powers" <david@example.com> wrote in message
news:ggpfel$59d$1@forums.macromedia.com...
> carbiz wrote:
>> I am trying to import a database from excel into mysql on myphpadmin. I
>> create the database name and the table and then to go import at top and
>> locate the cvs file, but I get a error every time #1064 error.
>
> #1064 is a SQL error. It's possible that your CVS uses MySQL reserved
> words. Without knowing what's in the CVS file, it's impossible to say.
>
> --
> David Powers, Adobe Community Expert
> Author, "The Essential Guide to Dreamweaver CS4",
> "PHP Solutions" & "PHP Object-Oriented Solutions"
> http://foundationphp.com/

N
Newsgroup_User
Inspiring
November 28, 2008
carbiz wrote:
> I am trying to import a database from excel into mysql on myphpadmin. I
> create the database name and the table and then to go import at top and locate
> the cvs file, but I get a error every time #1064 error.

#1064 is a SQL error. It's possible that your CVS uses MySQL reserved
words. Without knowing what's in the CVS file, it's impossible to say.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS4",
"PHP Solutions" & "PHP Object-Oriented Solutions"
http://foundationphp.com/
M
MardenwebAuthor
Known Participant
November 28, 2008
here is the file it called test.
Part# Title Cost
12345 Garmin 129

Thanks for any help you can provide. I also left you a message on your forum for your book, DW CS3 with CSS, Ajax, and PHP. I was able to connect to your sample database from your book and get input back from feedback_start_php file. What am I doing wrong??

Thanks,
Den
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices