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
if something like that exists.

seede

Junkone wrote:
> 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
> 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.