Importing Excel Sheet into Access Database using VBA

[fokruls]

hi,

i am using the transferspreadsheet:

DoCmd.TransferSpreadsheet transfertype:=acImport, _
tableName:=tableName, _
fileName:=fileName, Hasfieldnames:=True, _
Range:="'IT all'!",
SpreadsheetType:=acSpreadsheetTypeExcel9

I want to import a sheet called IT all from an Excel file. However it
is telling me that the IT all$ is not a valid name

Any ideas how can can do this?

Thanks in advance

 

[John Nurick]

Try "'IT all'$" or "[IT all]$".

If that fails, create a named range covering the cells you want to import
data from. Use a name that doesn't contain spaces, e.g. "IT_all" and pass
this to TransferSpreadsheet *without* using a ! or $.

 

[fokruls]

Thats done it!!!!

Thanks John!!

Your a hero!!

Try "'IT all'$" or "[IT all]$".

If that fails, create a named range covering the cells you want to import
data from. Use a name that doesn't contain spaces, e.g. "IT_all" and pass
this to TransferSpreadsheet *without* using a ! or $.

--
John Nurick
Microsoft Access MVP

hi,

i am using the transferspreadsheet:

DoCmd.TransferSpreadsheet transfertype:=acImport, _
tableName:=tableName, _
fileName:=fileName, Hasfieldnames:=True, _
Range:="'IT all'!",
SpreadsheetType:=acSpreadsheetTypeExcel9

I want to import a sheet called IT all from an Excel file. However it
is telling me that the IT all$ is not a valid name

Any ideas how can can do this?

Thanks in advance- Hide quoted text -- Show quoted text -