Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

import excel sheet1 to access table

Status
Not open for further replies.

GShen

MIS
Sep 26, 2002
561
US
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?
 
Loading to an access table using Microsoft OLE DB Provider For Sqlserver ???

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top