Here's a tool for $79 that might do the trick for you: http://dbconvert.com/convert-excel-to-mysql-pro.php?DB=9
Mikal On 12/31/2010 14:16, Ted Wolfley wrote: > You are right about mysql, I am most familiar with sql server. You will have > to export to a flat file using Beverly advice. I would think that you could > automate this step before importing. > > > -----Original Message----- > From: Fogelson, Steve [mailto:[email protected]] > Sent: Fri 12/31/2010 1:54 PM > To: [email protected] > Subject: RE: Witango-Talk: xls conversion > > Hi Ted, > > I am using MySQL. I didn't know you could import an xls file directly into > MySQL. Do you have a sample procedure you could share? > > I have used LOAD DATA INFILE but normally on comma delimited files. > > Thanks > > Steve > > -----Original Message----- > From: Ted Wolfley [mailto:[email protected]] > Sent: Friday, December 31, 2010 7:32 AM > To: [email protected] > Subject: RE: Witango-Talk: xls conversion > > What database are you using? > > It may be easier to use Witango for just putting the file into a directory > and then import the xls file into the database using a database procedure. > This would be more efficient if the file is large. > > > Ted > > > -----Original Message----- > From: Fogelson, Steve [mailto:[email protected]] > Sent: Fri 12/31/2010 12:35 AM > To: [email protected] > Subject: Witango-Talk: xls conversion > > Some of you may be familiar with auction sites that allow you to import > excel xls files of auction items into the auction. I am trying to do > something similar to this with Witango. > > > > Some of the columns may contain quotation marks to indicate a quote or maybe > signify inches. One column contains a number with leading zeroes. Some > columns contain html tags. > > > > I have tried opening the file with excel and saving as a csv file with a "|" > as the delimiter and then reading into Witango. Two problems seem to occur > with this method. Columns with number with leading zeroes lose the leading > zeros and "general" columns are enclosed with quotes. Not necessarily a > problem unless there are quotes in the field. > > > > I also need to be aware of potential SQL injection when importing these > files. > > > > Anyone have any experience with this and a possible solution? > > > > I tried to search the "list" but I can't find it on the Witango website > anymore. > > > > Thanks > > > > Steve Fogelson > > Internet Commerce Solutions > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. -- Mikal Anderson www.LakeOMedia.com "What has your website done for you lately?" This message, including any attachments, is confidential and intended solely for the person(s) or organization to whom it is addressed. If an NDA has been signed by the parties, this communication is governed by the stipulations contained within that NDA. If you are not the intended recipient, or have received this message by mistake, please notify Mikal Anderson, the original sender, and delete this message from your system. Any unauthorised use, forwarding, or other dissemination of this message, in whole or in part, is strictly prohibited. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
