pod 298
Contributor
Hello
I am importing Excel files data into an Access database. My script goes through one Excel file at a time, row by row, and build a SQL statement for each row to insert data into the database. But on one of the Excel files, it encountered a cell with the value "#VALUE" in it, and the macro stops dead, leaving no debug message, no error popup, it just stops, with Excel file hanging in the process.
Has anyone ever encountered this?
I am using 2003 now, just recently, I am wondering if it is not related.
Thanks
P :oD
2 1292
Hello
I am importing Excel files data into an Access database. My script goes through one Excel file at a time, row by row, and build a SQL statement for each row to insert data into the database. But on one of the Excel files, it encountered a cell with the value "#VALUE" in it, and the macro stops dead, leaving no debug message, no error popup, it just stops, with Excel file hanging in the process.
Has anyone ever encountered this?
I am using 2003 now, just recently, I am wondering if it is not related.
Thanks
P :oD
I've had some issues like that before. I just copied and pasted values in the spreadsheet before import to get rid of calculations and to replace #VALUE and #N/A values with numbers or data.
I didn't have to deal with handling large numbers of spreadsheets or on a repeated cycle, so if that is the case, it would be too time consuming.
What is your code doing in detail?
pod 298
Contributor
I've had some issues like that before. I just copied and pasted values in the spreadsheet before import to get rid of calculations and to replace #VALUE and #N/A values with numbers or data.
I didn't have to deal with handling large numbers of spreadsheets or on a repeated cycle, so if that is the case, it would be too time consuming.
What is your code doing in detail?
Hi Nathan
... my code reads the data in each cell and builds an INSERT SQL statement, and at the end of each row, the code executes the SQL statement.
I do have many EXCEL files to go through, 308 at a time.
These EXCEL files have MACROS in them, I presume that is where #VALUE came from... but I have been doing this for a few years, I have never encountered this problem before... but this is the first upgrade since then, I was using Access 2000 before
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: johnsuth |
last post by:
I want to produce a trivial demonstration of dynamic modification.
I thought that pressing a button might change its color.
I studied O'Reillys books and successfully created the button with a fancy
style, but the onclick fails to do anything no matter what permutation of
parameters I try.
<input type=button style=background-color:yellow;color:blue;font-family:Arial;font-style:italic;font-weight:bold name="xyz" value="CHANGE COLOUR"...
|
by: ahaque38 |
last post by:
Hello.
Using A2K SP3, I am having the following problem with a report using
"Sorting and Grouping".
I have recently added a grouping in the reports for
"Category2<>'CONTRACTS'".
I have reports at the plan (overall totals), department and division
levels which have sorting and grouping implemented with this new
|
by: maniac |
last post by:
Hey guys, I'm new here, just a simple question.
I'm learning to Program in C, and I was recommended a book called,
"Mastering C Pointers", just asking if any of you have read it,
and if it's worth the $25USD.
I'm just looking for a book on Pointers, because from what I've
read it's one of the toughest topics to understand.
thanks in advanced.
|
by: TTroy |
last post by:
Hello, can anyone explain why the following function will not work for
INT_MIN:
/* itoa: convert n to characters in s */
void itoa(int n, char s)
{
int i, sign;
if((sign = n) < 0) /* record sign */
|
by: IkBenHet |
last post by:
Hello,
I am uploading a file using this form in ASP.NET. I have also added a
simpel textfield:
<form runat="server" enctype="multipart/form-data">
<input type="file" id="oFile" Name="oFile" size="70" runat="Server">
<input type="text" SIZE="20" MAXLENGTH="20" id="Name" NAME="Name">
<input type="submit" id="Submit" runat="Server" value="Submit"
OnServerClick="SubmitButton_Click">
</form>
| |
by: Emi Lu |
last post by:
Hello all,
I have a question about "date" & "timestamp" types in PostgreSQL. I want
to setup the default value '0000-00-00' and "0000-00-00 00:00:00" for
them. However, it seems that PostgreSQL does not support it. Could
someone helps me please?
The example table:
T1 (col1 varchar(7) not null,
|
by: Darin |
last post by:
I have a problem I just can't figure out. I have a form with a
subform, and the recordsource of the subform has criteria based on
some unbound fields in the parent form so that data in the parent form
affects data in the subform. I've had this type of setup often, but
I've run across a couple forms where this has caused an "enter
parameter value" pop up for each reference to the parent control in
the query when the main form is closed. ...
|
by: mark |
last post by:
Forgive me if this seems like a stupid question but I need help...
I'm trying to do a simple online form that emails me the results from
a few fields.
Here is the code:
<form action="http://cm1web1/WebSurveyComponents/script/
processform.asp" method="post">
|
by: bodilima |
last post by:
Dear All,
I'm new to this!
I wanna insert selected values from form "SaveModel" to form "SaveMake" <input name="makeID" value="<<<<need to insert here(x)>>>>">
&
<input name="make" value="<<<<need to insert here(optvalue)>>>>">
when i try it works only for the selected value and in an instance it clears the <input...>.
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |