Hi Kul,
I've also changed the names (though I'm not 100% sure what's a "name range".
I found the following in the Excel 2003 Help file (sorry, I'm not using
Excel 2007):
Topic: Name cells in a workbook
Subtopic: Name a cell or a range of cells
Select the cell, range of cells, or nonadjacent selections that you want to
name.
Click the Name box at the left end of the formula bar.
Type the name for the cells.
Press ENTER.
Note You cannot name a cell while you are changing the contents of the cell.
_____________________
Make sure that the total path length (complete filename) does not exceed 218
characters. Excel reserves some characters for the worksheet names, so you do
not get the normal maximum of 255 characters.
Try the following experiment:
Create a brand new Excel spreadsheet, with some reasonable names for each
column.
Add some data of various data types (text, date, numbers) into different
columns.
Close the spreadsheet. Open a brand new Access database.
Can you import this data?
If the answer is "yes", then move on to the second test, below. If the
answer is "no", then you may have a corrupt accwiz.dll file, or an improperly
registered .dll file, such as the same accwiz.dll or perhaps dao360.dll. Oh,
by the way, which versions of Access and Excel are you using? Which service
pack are you running?
Test # 2 (to be run only if Test # 1 is successful)
Try exporting the data from Excel to a comma separated variable (*.csv) file.
Then use File | Open in Excel, and try bringing the same data back into Excel.
Save the new spreadsheet. Can you import it now?
Note: You might also try directly importing the text file into Access.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________