Copy & Paste From Excel

[bills249]

Is there any way to copy & paste multiple columns of data from an Excel spreadsheet into a web form with multiple text boxes? The data will be going to a SQL database. :confused:

[russell]

y not just import excel into db?

[ray326]

What russell said. If it's coming from external sources then upload/import would be your best bet. Using a web form as a literal transfer medium would be looney.

[russell]

if it's a sql server db, use dts ( or if sql2k5, ssis import ). very quick and easy. often best to save excel sheet to tab delimited text file first, as dts sometimes guesses wrong about data type when importing excel format.

[bills249]

Thanks for the responses and input. The Excel file is generated from another database that I do not have permission to access as far as importing data. The file I have to work with is not very database friendly for importing data, it was set up to print as a report with multiple column headings on different rows. Thanks again.