All,
I am trying to import a table from Excel, but I get the 3709 error,
search key not found. Any ideas? My TransferSpreads heet method
statement is:
DoCmd.TransferS preadsheet acImport, , "tblStaging ", strFilePath &
"Temp.xls", True, ""
Thanks in advance,
Sarah 1 2250
I suspect the empty string parameter you have specified for Range is causing
the problem, try this.
DoCmd.TransferS preadsheet acImport, , "tblStaging ", strFilePath &
"Temp.xls", True
"SarahK" <sa*******@hotm ail.comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...
All,
I am trying to import a table from Excel, but I get the 3709 error,
search key not found. Any ideas? My TransferSpreads heet method
statement is:
DoCmd.TransferS preadsheet acImport, , "tblStaging ", strFilePath &
"Temp.xls", True, ""
Thanks in advance,
Sarah This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Steve Claflin |
last post by:
I have a database with a moderate number of records in several tables
(the biggest table at the moment is about 800 records). In development
it got moved between 2K and XP repeatedly. Several days ago, it
wouldn't open, and proposed creating a backup before fixing. OK, but
the "fixed version" didn't open -- same messages as the original -- but
the backup did. But, in the 800 record table only 200 records
appeared. We went back several...
|
by: mark |
last post by:
In Access 2000 and 2002, I have created an import specification to import the
fixed-width recordset below into an existing table. I am having strange
problems with the import of the date and time fields.
177 102003 16:43:12 102003 18:43:12 6OAG0ADP Y 0000 0000 0000 0000 61930 4HGA800
165 102003 17:43:12 102003 18:44:12 6OAG0ADP Y 0000 0000 0000 0000 61930 4HGA800
177 102003 16:41:18 102003 18:45:12 6OAG0ADP Y 0000 0000 0000 0000 61930...
|
by: Maurice |
last post by:
Folks
once again I look forward to your invaluable assistance.
When converting an Access 2002 mdb back to Access 1997 using the Access 2002
inbuilt tools I receive the following error message "Some errors happened
during the conversion. No converted database was generated". This message is
not of great assistance to me in sorting out the error!!
I have not been able to find any helpful support on where to start looking
|
by: Roald Oines |
last post by:
Hi,
I'm working on converting several of my Access 97 databases to Access
2002 format (the company's changing from NT 4 to XP and updating Office
at the same time), and this one has me stumped. As a performance
enhancer, I use VBA code (transfertext) to export the results of a query
(usually 20-30 thousand rows with a few dozen fields of customer
information) to the user's temp folder as a text file and then link to
it using a text file...
|
by: Sebastian C. |
last post by:
Hello everybody
Since I upgraded my Office XP Professional to SP3 I got strange
behaviour.
Pieces of code which works for 3 years now are suddenly stop to work
properly.
I have Office XP Developer (SP3 for Office, SP1 for developer,
JET40SP8) on Windows XP Home Edition (SP1). The same behaviour occurs
on Windows 98 too.
| |
by: JoeBobHankey |
last post by:
Background:
- I'm running MSDE 2000 (not client tools, stored procedure capability,
etc). This may change, but not in the first part of development.
- My Access file is an Access 2002 project (.adp project client
connecting directly to MSDE SQL database - no .mdb involved or local
file tables beyond the .dbfs to be imported).
- Using ODBC to connect to .dbf data sources without a problem (ODBC is
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of...
|
by: maztoo |
last post by:
Hi
I've seen this problem posted on this group in the past but I am yet to
find a solution to the problem.
I'm trying to import a simple spreadsheet into Access but am getting a
message saying 'An error occurred trying to import the file
C:\blah\blah.xls. The file was not imported'. I try and import the
file by going to the file menu in Access - Get External Data -
Import...
|
by: ladybug via AccessMonster.com |
last post by:
I am trying to change the data in a text field in a table. I can change this
field in other entries, but one specific one I receive this error:
The search key was not found in any record. (Error 3709)
This error occurs when an ISAM SEEK is being executed and there are no
matching values in the index.
I do not understand. What does this mean?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |