dbTalk Databases Forums  

excel macro to create insert statements

comp.databases.mysql comp.databases.mysql


Discuss excel macro to create insert statements in the comp.databases.mysql forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Junkone
 
Posts: n/a

Default excel macro to create insert statements - 01-06-2008 , 05:48 PM






are there any excel macros that will create insert statements. i tried
the data loader, if the data looks like this
,1/7/2008,STOCK,,1,1,,MYGN,1,,23.3
it zeros the date and puts 0 where the number value is no value. i
want to use a macro that will wriet a custom sql but could use some
help if something like that exists.

seede

Reply With Quote
  #2  
Old   
Paul Lautman
 
Posts: n/a

Default Re: excel macro to create insert statements - 01-06-2008 , 06:10 PM






Junkone wrote:
Quote:
are there any excel macros that will create insert statements. i tried
the data loader, if the data looks like this
,1/7/2008,STOCK,,1,1,,MYGN,1,,23.3
it zeros the date and puts 0 where the number value is no value. i
want to use a macro that will wriet a custom sql but could use some
help if something like that exists.

seede
I use Excel for this sort of thing very often. However, I just use a formula
to create all the value sets for an extended insert.




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.