(Msg. 1) Posted: Mon Sep 08, 2003 11:09 pm
Post subject: Reading a text file in Excel using SQL.REQUEST Archived from groups: microsoft>public>excel>datamap (more info?)
I simply cannot get it to work. Assuming a file test1.txt in c:\temp
=SQL.REQUEST(B1;C15; 2;"SELECT * FROM TEST1.TXT";TRUE)
Where B1 contains DSN=FB;DBQ=C:\TEMP always returns a value error. Any
ideas what I am doing wrong? I can query the file from MS Query and
linking EXcel to other databases work OK.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office