Thursday, March 8, 2012

Copy data from excel spreadsheet and paste to table

I have an excel spreadsheet and I want to transport its data into a table. I have tried copying and pasting but it doesn't work. Any ideas?

Give OPENROWSET a look in books online; judging from your past posts over the past couple of days, you really do need to get a good boock and try working some of the excercises.

|||Its better to use Import\Export Wizard which is much easier to work.

No comments:

Post a Comment