Can't import files into access from excel 2

[gd]

Ok I should be able to import an excel spreadsheet into access by using the File...Get External Data...Import...<br><br>Problem1: Excel is not one of the file types I can import<br>Problem2: When I go to add/remove programs and try to add excel as one of the import items the check box is checked, grey, and the word installed is printed beside it. <br><br>Doing a complete removal of access and excel and reinstalling does not work.&nbsp;&nbsp;<br><br>I think this means that the appropriate files are on my computer somewhere. I just don't know how to find them or more importantly get access to find them.<br><br>I would appreciate any help I can get because if I can't get this to work soon I'm going to have to start from scratch with my computer.<br><br>

 

[Dreamboat]

Go to the Control Panel under ODBC Data sources 32 bit. If you don't see Excel under USER DSN, and I suspect you won't, hit ADD. It's not hard to see how to do it. Repost if you need more help. <p> <br><a href=mailto: dreamboat@nni.com> dreamboat@nni.com</a><br><a href=

http://www.wedomanuals.com>

</a><br>

 

[tania]

You can search and rename the following files:<br>MSEXCL35.dll<br>MSSTEXT35.dll<br>MSXBSE35.dll<br><br>Then run the setup program from Access again and choose Add/Remove.<br>In the options box, select Data Access, and then click change option.<br>In the data access options box, click database drivers, and then click change option and select the desired option.<br>Click ok twice and continue.<br><br>We had the same problem and now it's working!<br>I hope it will help you too!<br>

 

[runningbear]

Tania's fix worked great for me, thanks Tania

 

[warpdrve]

Even though importing usually works when bringing Excel data into Access, I find myself usually just selecting the spreadsheet (including header row), copying, and pasting into a new table in Access. This is often a lot faster than importing.

Another trick I sometimes use is to save the excel file in .dbf format which Access can link or import easily.