[AccessD] TransferText Failling

Well, that solved it.  Thanks.  .txt works.  But I think Seth is probably
right as well.  I've used direct I/O and it's really simple and real
effective.  That was going to be my next move but I was just lazy and trying
to save a few lines of code.

Rocky

----- Original Message -----
From: "Gary Kjos" <garykjos at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Monday, March 10, 2003 11:15 AM
Subject: Re: [AccessD] TransferText Failling


> Hi Rocky,
>
> What is the extension of the filename you are trying to export to?
Remember
> that Access is particular about that and will only export to .txt or .csv
or
> .tab or a couple other magic extensions.
>
> Gary Kjos
> garykjos at hotmail.com
>
>
> >From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
> >Reply-To: accessd at databaseadvisors.com
> >To: <AccessD at databaseadvisors.com>
> >Subject: [AccessD] TransferText Failling
> >Date: Mon, 10 Mar 2003 10:07:04 -0800
> >
> >Dear List
> >
> >I'm trying to use the TransferText method of exporting a table to a comma
> >delimited file.  I get "Error 3027: Cannot Update.  Database or object is
> >read-only" when issuing:
> >
> >DoCmd.TransferText acExportDelim, , "tblAddRooms", varFileName
> >
> >where varFileName contains a valid path and file name.  Has anyone seen
> >this before? I have but can't remember why or what the fix was.
> >
> >MTIA,
> >
> >Rocky Smolin
> >Beach Access Software
> >
> >
>
>
> _________________________________________________________________
> MSN 8 with e-mail virus protection service: 2 months FREE*
> http://join.msn.com/?page=features/virus
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>