473,324 Members | 2,473 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Problems with HTML Imports

Perhaps someone has experience these two problems and if there are any
fixes or workarounds, I sure would like to know. I'm using Access 97.

When exporting data in html from one database that includes the "time"
in any format, during the import process there is an error and creates
a table indicating that it is a "Type Conversion Error." I have checked
the table field type in the import database and it is correct -
Date/Time, including the import Specs. Any date without the time is
imported with no problems. Does anyone have any ideas what is causing
this error?

The other html import problem relates to null fields in the export
database. After the data is imported, the code using null expressions
fails because technically the fields are not null. Hitting the delete
twice clears whatever is in the field and makes it null and the code
runs fine. Apparently, there are two hidden/invisible characters in all
of the imported null fields. They are not zero length strings - try
that approach. Have been unable to display what they are and have
assumed that they are some type of html tags. Does anyone know of a
workaround for this problem?

Thanks for your time and assistance.

Nov 13 '05 #1
1 1183
Rolan wrote:
Perhaps someone has experience these two problems and if there are any
fixes or workarounds, I sure would like to know. I'm using Access 97.

When exporting data in html from one database that includes the "time"
in any format, during the import process there is an error and creates
a table indicating that it is a "Type Conversion Error." I have
checked the table field type in the import database and it is correct
- Date/Time, including the import Specs. Any date without the time is
imported with no problems. Does anyone have any ideas what is causing
this error?

The other html import problem relates to null fields in the export
database. After the data is imported, the code using null expressions
fails because technically the fields are not null. Hitting the delete
twice clears whatever is in the field and makes it null and the code
runs fine. Apparently, there are two hidden/invisible characters in
all of the imported null fields. They are not zero length strings -
try that approach. Have been unable to display what they are and have
assumed that they are some type of html tags. Does anyone know of a
workaround for this problem?

Thanks for your time and assistance.


Why you are using HTML format to transfer data between databases? Frankly, I'm
surprised it works at all.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: jason | last post by:
Hello. I've got this simple collection populate code I downloaded from the net (sorry can't find source now) I'm trying to test, but I can't seem to get it to work. Any help would be greatly...
7
by: Tappy Tibbons | last post by:
We are writing a dotnet app that among other things retrieves messages from a standard POP3 mailbox, and then performs certain actions with that email automatically. Some of the emails are...
1
by: nate axtell | last post by:
In VB .Net I made a custom CheckBox column style (for the Datagrid control) that maps to two DataTable columns , one it uses for the Checked status and the other it uses for the Enabled status. I am...
0
by: ZR | last post by:
I am writing two applications which needs to (among other things) communicate through network, so one of them is a client and the other one is a server. I have used asynchronous socket examples...
1
by: Ed Dror | last post by:
Hi there, I have ASP <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Guestbook.aspx.vb" Inherits="Guestbook" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"...
0
by: David | last post by:
Hello all. I am trying to implement my first server control and have run into two problems that I cannot solve. I need the assistance of someone with more experience. My goal was to create an...
3
by: sjt003 | last post by:
I have been developing web apps in Visual Studio 2003, but since the other developers in my office don't use Visual Studio, I may have to stop too unless there is an efficient way for them to...
0
by: Wanxi | last post by:
Hi everyone, I am testing one of the example -> <UsingTheSerialPort> at VB101SamplesBCL2. But there are some error which i don't know how to edit. I found some post that having the same problem...
0
by: Scott McNair | last post by:
My apologies for crossposting this; I originally posted it to m.p.d.l.vb.data, but then I noticed that the group is not very active so I decided to post here as well. Subject: Problems creating...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.