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
|
|
0
|
|
|
|
Reply
|
 Junkone
|
1/6/2008 10:48:12 PM |
|
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
> 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.
|
|
|
0
|
|
|
|
Reply
|
Paul
|
1/6/2008 11:10:29 PM
|
|
|
1 Replies
522 Views
(page loaded in 0.03 seconds)
Similiar Articles: excel macro to create insert statements - comp.databases.mysql ...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... use macro to import multiple excel files? - comp.soft-sys.sas ...excel macro to create insert statements - comp.databases.mysql ... use macro to import multiple excel files? - comp.soft-sys.sas ... how can i use macro to import multiple ... Using Excel without Macros - comp.lang.perl.miscexcel macro to create insert statements - comp.databases.mysql ... From Excel - Access Create ... use macro to import multiple excel ... lets you migrate data from Excel ... Where clause usage in %if in macro - comp.soft-sys.sasexcel macro to create insert statements - comp.databases.mysql ... From Excel - Access Create ... use macro to import multiple excel ... from Excel to SQL Server The ... SPSS MACRO Syntax - comp.soft-sys.stat.spssexcel macro to create insert statements - comp.databases.mysql ... Beginning Tutorials macro, a macro variable, a macro statement ... Insert A Variable Using Syntax - comp ... creating and inserting SLDLFP's - comp.cad.solidworksexcel macro to create insert statements - comp.databases.mysql ... are there any excel macros that will create insert statements. i tried the data loader, if the data ... Excel COM server - comp.soft-sys.matlabexcel macro to create insert statements - comp.databases.mysql ... Excel Macro Creates INSERT Statements for Easy Data Migration Here’s a solution that lets you migrate ... Insert A Variable Using Syntax - comp.soft-sys.stat.spss ...> > Thanks Create the new variable in the ... variable size data from matlab to Excel files - comp ... Insert A ... can be used as a table source in an INSERT statement ... how to count the number of elements in a macro variable? - comp ...excel macro to create insert statements - comp.databases.mysql ... how to count the number of elements in a macro variable? - comp ... Just change the DO statement ... Re: Anyone familiar with Excel 4 macro language? - comp.soft-sys ...... next()]'; > put '[workbook.insert(3)]'; > run; > > /*Create and run the macro*/ > filename xlmacro dde 'excel|macro1 ... would be oversimplifying the problem statement Excel Macro Creates INSERT Statements for Easy Data MigrationHere’s a solution that lets you migrate data from Excel to SQL Server without having to manually create INSERT statements or use SQL Server Management Studio’s ... excel macro to create insert statements - comp.databases.mysql ...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... 7/23/2012 9:20:49 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
8 followers. 