Linking to an Excel Spreadsheet

[wan2fly99]

have setup a link to an Excel spreadsheet. When I open the table which
is linking to the spreadsheet in Access I see some cells with values of
#Num! in them.

I noticed that Access thinks they are numbers. The spreadsheet has a
variety of values
for that cell.

Went back to the spreadsheet and tried to change the format for the cells.
Said it was text.

Now access shows the values that are only all text. Anything with a number
I get the #Num! value.

This cell contains a mix of values. How can O show that?

 

[wan2fly99]

Okay thanks for the suggestion. Will try that.

Also I tried to import a spread sheet with some code.

Here it is

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click


DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportTable", "c:/Tony.xls"


Exit_Command0_Click:
Exit Sub

Do you know what I have to type in for the Excel Spreead sheet to pick up a specific sheet?

Spreadsheet is called: Tony.xls. It has 3 different sheets inside. I would just like to import a specific one