Re: My First Script - Help Please

Troubled User wrote:
On 30 May 2006 11:17:29 -0700, "Jeff C" <jpcoulson@xxxxxxxxxxx> wrote:
db.Execute("DoCmd.TransferText") ("acImportFixed"), ("My
ImportSpec"), ("Name Of My Table where data will go"), ("Full Path
Of Text File To Import")

Sorry havn't used DAO in years.. Any particular reason why your using
that rather then ADO

Well, neither is appropriate for running TransferText, which is a method
of the DoCmd object which is a property of the Access Application
object. See my reply.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: ADO via VBA on Server 2000?
    ... ADO so I can call SQL from VBA. ... reason I wouldn't be able to run this macro on Windows Server 2000? ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: Cyril & Phyllis Annear family
    ... This is a genealogy newsgroup and not a vehicle for ... If you want to find living persons, do it in the proper way through ... suspicious when a poster does not state a reason for seeking, ... threatens physical violence against those who have sussed you? ...
    (soc.genealogy.britain)
  • Re: Brand Spankin Newbie ADO.NET Question
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > examples in my Apress book "ADO.NET and ADO Examples and Best Practices" ... > Microsoft MVP ... > Please reply only to the newsgroup so that others can benefit. ...
    (microsoft.public.vb.database.ado)
  • Re: Java 7 features
    ... the intersection of the two yields "a Seinfeld newsgroup" as ... Seems like a stretch to me, for the reason given below. ... chalk it up to the snowball effect: one attacker gets believed by some ... of growth of the set of attackers, ...
    (comp.lang.java.programmer)