I need to write a little program that reads data from one access database into sql server database. for the record, the two database have similar database with similar fields except that the sql database has two extra fields in each table.
I can read from each access table and write that info into sql tables, but i think it will be long because i have to code all the field parameters. and some table has more that 45 fields. it might take long.
I thank you in advance.