[mso] Re: Access and ADO
- From: "Green" <1z@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 7 Nov 2003 22:58:51 +0100
Hi Dian,
First off, Thank you for replying.
I've used dao for a long time now and I know I'm 200 years too late
but I'm trying to use ado for this. I guess I'll get around to .net in
another 200 years :-)
I have a comma delimited txt file coming out of a non office
application... actually autocad. It's produced automatically as part
of the plot/print process. Once in access my plan is to use queries to
base reports on.
I'm Sorry if this is outside of group scope and I'll keep looking
elsewhere if it is... apologies.
So anyway, I'm trying to read it as a recordset in ado. My first
question/problem is... I can connect to the record set but when I try
to open it with an sql select * from file, I get can't work with the
record set...(translation from Dutch) "-2147217911 (80040e00". A web
search says that this is because of permissions. This is an XP home
stand alone computer and I'm stuck.
The trick is... this seems to be because the file has a .LOG
extension. If I copy the log file and change it to a .TXT file then
the sql works fine.
I *can* read the data with dao, but one of the reasons I'm trying to
use dao is because of future web stuff.
My second question is... is this a good idea? I'm not really all that
sure. Part of the thinking is to make the data "live"... that is the
recordset would be updated everytime the log file was written to...
but really I just don't know enough.
Any help or thoughts would be appreciated.
... and thankyou again.
Regards
Lisa
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
> Behalf Of Dian Chapman
> Sent: 07 November 2003 20:36
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: Access and ADO
>
>
>
> I use ADO/SQL/VBS all the time...whatcha need?
>
> And yes, this IS within the scope of this group IF used
> within Office...just
> like VBA.
>
> --------------------------------------------
> Dian D. Chapman
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
