Quote:
Originally Posted by Lee Dumond
An MDB is an file you can open in Access. Of course, if you open a database in Access, then you can paste into it.
However, there is no way you are going to paste a column of values into an MDF. That doesn't make any sense. MDFs are meant to be edited using DDL. There's no such concept as "pasting" data into an MDF.
|
Well, I just try it.. I open my SQL server management express, open a database with a table with id, name. (id is not autonumeric, was just numeric). Open excel, create 3 dummy rows of data with number, text. I copy all the sheet, went to SQL, pressed CTRV+V and worked.
Quote:
Originally Posted by Lee Dumond
Ah yes, I get it. That would work. Never thought of that. That's actually pretty clever Gonz!  . And, probably a lot faster than using a file I/O thing like a StreamReader for a one-time procedure. |
Thanks for that
I do that kinds of things a lot, excel is very helpfull even when you need to do some programing. It helps building lines of code that are similar. (I once has to output about 5k chars to a single line of a file, they came from properties of a class, and excel help build the 100+ lines of equally code for them).
A good blog post will be welcomed, I will be looking forward for it.
