Hi Won On Mon, Feb 16, 2009 at 11:44 AM, Won Lee <[email protected]> wrote: > >>Quick question. I have a large data set which is delivered to me via CD >>every quarter. I need to get this data into a MySQL server. >> >>What are my options? I know I could probably do this via PERL or VB but >>it seems like a rather mundane task and something where a tool already >>exists. >> >>W > > I should also add that the format is somewhat odd. The data is supplied by > Arbitron. I'm looking through one of their CDs now. I don't know what their > policy is about posting their data so I can't post a sample until I find out > for sure. > > A straight import won't work because each row isn't part of the same data set. >
Is there a rowtype ID in the tables, distinguishing the types of rows? e.g., some rows go to one table with one set of fields, others go to a child table with another set of fields. One thing we've done (where there was a rowtype ID in the first column) is import into a "raw import" SQL table that has that first rowtype field and the rest are varchar; just load file directly into there (one for each text file), then you can select based on that rowtype field to split out into the real tables with real datatypes. - D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319428 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
