Subject | Re: [IBO] IB Data Pump and MS Access |
---|---|
Author | Daniel Rail |
Post date | 2004-08-28T11:41:15Z |
Hi,
At August 28, 2004, 04:43, homerjones1941 wrote:
a time. And, yes it's going to be slow, but what I found is that it's
the connection with MS Access via ADO that slows down the process. If
there would be a better/faster way to import data from an MS Access
DB, I'd probably be using it, unless I didn't hear about it.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At August 28, 2004, 04:43, homerjones1941 wrote:
> Thanks for suggesting some alternatives. Unfortunately, the AccessI know what you mean.
> database has Blob fields in many of the tables. Also, it is part of
> a commercial app and is installed in hundreds of locations scattered
> all over the US. The data pumping needs to be be pretty invisible to
> the end user.
> I was hoping to find something more direct than making intermediateUnfortunately, any datapump component will do the import one record at
> tables. I am now toying with reading records from the Access tables
> via ADO, and then writing them into FB. I've done this kind of thing
> before, and one record at a time is painfully slow.
a time. And, yes it's going to be slow, but what I found is that it's
the connection with MS Access via ADO that slows down the process. If
there would be a better/faster way to import data from an MS Access
DB, I'd probably be using it, unless I didn't hear about it.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)