Hi,
I have to missing something here. Using the wizard.
1) Select excel as the input file. .....No problem.
2) Destination file - Microsoft OLE DB Provider For Sqlserver .... No problem.
3) Select the server name and database. .... No problem.
4) Check off radio button for Copy data from one or more tables or views ... No problem.
5) Select Sheet 1 and preview.... No problem.
6) Ignore heading checked off and delete file upon load checked off.
7) Select destination table by selecting drop down and finding my table ... No problem.
8) Go in to destination table and edit mappings and map every field from the sheet to the
destination Access table.... No Problem.
9) Click next and a million warnings come up!! I tried every possible way of getting rid of the warnings. Ignoring, fail, remove conversion, global, and the list goes on and on.
can anyone please guide me as to what the issue is ?
Remember when... everything worked and there was a reason for it?
I have to missing something here. Using the wizard.
1) Select excel as the input file. .....No problem.
2) Destination file - Microsoft OLE DB Provider For Sqlserver .... No problem.
3) Select the server name and database. .... No problem.
4) Check off radio button for Copy data from one or more tables or views ... No problem.
5) Select Sheet 1 and preview.... No problem.
6) Ignore heading checked off and delete file upon load checked off.
7) Select destination table by selecting drop down and finding my table ... No problem.
8) Go in to destination table and edit mappings and map every field from the sheet to the
destination Access table.... No Problem.
9) Click next and a million warnings come up!! I tried every possible way of getting rid of the warnings. Ignoring, fail, remove conversion, global, and the list goes on and on.
can anyone please guide me as to what the issue is ?
Remember when... everything worked and there was a reason for it?