Lee-
Why not import the file? DoCmd.TransferText should do that with no muss nor
fuss. You can use DAO to delete the imported table after you're done with it.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lee
Sent: Monday, September 26, 2011 6:34 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Link to .csv file... but only for a second (DAO)
Hi,
I have a .csv file I want to link to, but I don't want the link to persist. The
reason is because there is a scheduled job on the network that updates the .csv
file and if the file is open, the job fails and I get a call from MIS yelling at
me.
I just want to quickly link to the .csv file, run a quick query against it, then
get rid of the link. I was messing around with DAO but I can't figure out how
to create a NEW link (although I can refresh existing links), and I'm not sure
if I put import specs in the connection string or not. I don't really have
anything to show in terms of code because I'm totally stuck. I can't find the
dao.tabledef property to create a new connection, or should I be using tabledefs
append method somehow?
Thanks
-Lee
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar