basic question - cannot get the range name correct when importing Excel worksheet

Hey there,

I am trying to import an excel spreadsheet using the code below. Every
time it gives me a "cannot locate object" error.

Does anyone know what I am doing wrong?

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Lexington Hurns!Total Cvue Data"
Thank you in advance,

JC

Oct 6 '06 #1

Subscribe Post Reply

1904

Cyberwolf

Try this

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Total Cvue Data!"
HTH

JC wrote:

Hey there,

I am trying to import an excel spreadsheet using the code below. Every
time it gives me a "cannot locate object" error.

Does anyone know what I am doing wrong?

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Lexington Hurns!Total Cvue Data"

>

Thank you in advance,

JC

Oct 6 '06 #2

Thanks CyberWolf

That did the trick. I knew I was missing something small.

Justin

Cyberwolf wrote:

Try this

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Total Cvue Data!"
HTH

JC wrote:
Hey there,

I am trying to import an excel spreadsheet using the code below. Every
time it gives me a "cannot locate object" error.

Does anyone know what I am doing wrong?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTest",
"H:\everyone\Shared\ASC Processes\State Aid Processing
Databases\Lexington Hurns.xls", 0, "Lexington Hurns!Total Cvue Data"

Thank you in advance,

JC

Oct 6 '06 #3

by: deko | last post by:

I use a complied query to export to Excel like this: SELECT * INTO . FROM tblExcelData; But I have a situation where I need to export several tables into the same worksheet. The idea is to...

Microsoft Access / VBA

Cannot work with Excel component

by: acharyaks | last post by:

Hi life saver, I am using excel component for the development. The purpose is to connect to excel through the odbc connection string. Then through the connection extract data into a dataset and...

C# / C Sharp

C# and Excel Object range

by: Maik | last post by:

Hello, I've got a problem with access to special ranges. I renamed some cells (for example "C4" in "CUSTOM.GENERAL.VPRIM"). This is necessary, because I have to read out only these cells in...

C# / C Sharp

Excel.Range.Name gives error an exception

by: IMS.Rushikesh | last post by:

Hi All, I am trying to execute below code but it gives me an COMException ///// Code Start //// public string GetName(Excel.Range range) { try { if (range.Name != null)

C# / C Sharp

After export to Excel, that excel cannot open

by: Agnes | last post by:

Dim dsExcelExport As New System.Data.DataSet Dim daExcelExport As New System.Data.SqlClient.SqlDataAdapter Dim Excel As New Excel.Application Dim strExcelFile As String Dim strFileName As...

Visual Basic .NET

Visual Basic Editor Excel: using filters

by: marknoten | last post by:

I have an excel file with columns A, B, C, D and E that look like this: A B C D E ----------------------------------------------------- N 23,179 15,744...

Visual Basic 4 / 5 / 6

Insert from excel to access works, update I cannot figure out the proper code

by: bbasberg | last post by:

I have been working hard to clean up my code but I am still wondering why all incoming records go to the "AddNew" part of the IF statement and never to the Edit alternative. I believe that it must be...

Visual Basic 4 / 5 / 6

Cannot create ActiveX component

by: Administrator | last post by:

Hi, My web development server is a Windows 2000 SP4 system. Had created an aspx page with the following code which I had extracted from 1 of the Microsoft websites: Dim oExcel As Object Dim...

ASP.NET

Excel Automation-With Visual Basic 6

by: Esmael | last post by:

Hi to all, /*****************************/ OS-WIn XP SP2 VB6 SP6 /*****************************/ Is their anyone who can help me with this: Source code written on VB6.

Visual Basic 4 / 5 / 6

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

basic question - cannot get the range name correct when importing Excel worksheet

Similar topics