Inserting Excel spreadsheet data in to Sybase table

[PDShah]

How can I insert the data from Excel spreadsheet in to Sybase ASE12.5 table? I have a spread sheet with 7 columns and a table with 5 columns. I need to right a macro in Excel spreadsheet which can insert the data from column 1,2,4,6,7 in to the table. The data type for this columns matches data type of corresponding columns in the table.

Thanks

 

[qyllr]

hello,

what platform are you using? nt or unix? or both? try developing your data extract and the insert statement generation in perl...

hth,
q.

 

[PDShah]

We on running Excel spreadsheet from NT. The Sybase ASE server is on Unix. What if I want to insert the data thru a macro button?

Thanks for you reply.

 

[qyllr]

hello,

never tried that, sorry...

q.

 

[PDShah]

No problem buddy... thanks for trying!!