Re: Can't seem to use FileSystemObject
- From: brigitte@xxxxxx
- Date: 7 Mar 2007 06:01:47 -0800
On 6 mar, 17:24, "Tom" <rtmn...@xxxxxxxxxx> wrote:
Have you tried Chuck Grimsby's solution at: http://www.mvps.org/access/modules/mdl0057.htm.
It might solve both your issues.
Tom
I didn't even know this existed.
Thank you Tom, I'll check it out!
Bob:
I can't confirm that the file is a genuine csv. It has the csv
extension and is comma delimited, despite the lack of quotation marks
around text fields.
I'm working in Access, and I would be using automation to make Excel
open the file (because for unexplainable reasons, Excel reads it
properly and Access does not).
I haven't got as far as getting an error message. The editor doesn't
recognize the object or the function, so I'm assuming something along
the line of "undefined function". Is there any instance of the editor
not recognizing a function like that but still running it fine?
I was avoiding using TransferText on the csv because since Access does
not read the file properly, I was reluctant to put it into a table (I
would have extra fields for some records, which I'm afraid would
complicate things). Unless I'm reading the help file wrong and
TransferText doesn't put the data in a table?
OpenTextFile is an alternate way of reading a file, this time line by
line and as straight text, that I found in the help of the visual
basic editor. I've seen it refered to in this group when I searched
for it, but I can't honestly tell you whether it works in Access 2003.
All I know is that it's not working for me, thus my initial post.
I hope this clears things up, thanks for your reply. I'm going to
check Chuck Grimsby's solution and I'll post again if that doesn't
help.
.
- References:
- Can't seem to use FileSystemObject
- From: brigitte
- Re: Can't seem to use FileSystemObject
- From: Tom
- Can't seem to use FileSystemObject
- Prev by Date: Re: Get Value from Previous Record for this record
- Next by Date: Re: Easy for you, new to me
- Previous by thread: Re: Can't seem to use FileSystemObject
- Next by thread: INSERT INTO using memo fields
- Index(es):
Relevant Pages
|
Loading
