From: Susan C. <hom...@ya...> - 2006-07-13 00:45:17
|
Hi Rob, You're right - I wasn't very clear stating what I wanted... but right now I would be happy with either way, and the way you suggested will work fine for now. I was thinking about something that did not include the insert statement itself, but was more of the format of: | row 1 data | row 2 data | However, the insert statements created the way you suggested will be fine. Thanks very much for your answer! Regards, Susan ----- Original Message ---- From: Robert Manning <rob...@gm...> To: Susan Cline <hom...@ya...> Cc: squ...@li...; hom...@pa... Sent: Wednesday, July 12, 2006 5:24:02 PM Subject: Re: [Squirrel-sql-users] Exporting all rows in a table to an sql file On 7/12/06, Susan Cline <hom...@ya...> wrote: > > I'm trying to figure out how to export all of the data in a table to a 'load' file - something that > has delimeters that are appropriate for import. > "delimiters that are appropriate for import" into what and using what tool? I could interpret this to mean import into another SQL database using SQL insert statements delimited by semi-colons. If that were the case, then right-click on a table and choose "Create Data Script". If what you are looking for is raw data (without SQL) then refer to Gerd's response. Rob |