i'm looking for the simplest piece of code that will copy a whole table from an access database to a sqlserver database.
the sqlserver database is empty, there are no constraints, relationships or primary keys.
the structure of both tables is identical (or as identical as can be)
i'm assuming there is a couple of lines of code that will do it, presumably using datatables, dataadapters etc.
i'm using system.data.common for all data objects.
thanks very much