Databases
StackOverflow2013
Postsdbo
POvbscript to export an access query to a tab delimited file not working
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POvbscript to export an access query to a tab delimited file not working
    primarykey
    data
    text
    <p>I have this code:</p> <pre><code>db = "C:\Dokumente und Einstellungen\hom\Anwendungsdaten\BayWotch4\Neuer Ordner\baywotch.db5" TextExportFile = "C:\Dokumente und Einstellungen\hom\Anwendungsdaten\BayWotch4\Neuer Ordner\Exp.txt" Set cn = CreateObject("ADODB.Connection") Set rs = CreateObject("ADODB.Recordset") cn.Open _ "Provider = Microsoft.Jet.OLEDB.4.0; " &amp; _ "Data Source =" &amp; db strSQL = "SELECT * FROM tblAuction1" rs.Open strSQL, cn, 3, 3 Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.CreateTextFile(TextExportFile, True) a = rs.GetString f.WriteLine a f.Close </code></pre> <p>Which is meant to connect to an access database and produce a tab delimited text file. tblAuction1 is a query in the database, and definitly exists and is not misspelt in any way, but I get an error that it cannot be found or does not exist. When I change it to tblAuction which is the name of the table, I get an error stating f.WriteLine a has been called incorrectly.</p> <p>edit: I now only get a problem with f.writeline a, saying an incorrect argument has been supplied. I no longer have a problem with tblAuction1</p> <p>edit: the sql code used for my query:</p> <pre><code>SELECT tblAuction.article_no, tblAuction.article_name, tblAuction.subtitle, tblAuction.current_bid, tblAuction.start_price, tblAuction.bid_count, tblAuction.quant_total, tblAuction.quant_sold, tblAuction.start, tblAuction.ends, tblAuction.origin_end, tblUser.user_name, tblAuction.best_bidder_id, tblAuction.finished, tblAuction.watch, tblAuction.buyitnow_price, tblAuction.pic_url, tblAuction.private_auction, tblAuction.auction_type, tblAuction.insert_date, tblAuction.update_date, tblAuction.cat_1_id, tblAuction.cat_2_id, tblAuction.article_desc, tblAuction.countrycode, tblAuction.location, tblAuction.condition, tblAuction.revised, tblAuction.paypal_accept, tblAuction.pre_terminated, tblAuction.shipping_to, tblAuction.fee_insertion, tblAuction.fee_final, tblAuction.fee_listing, tblAuction.pic_xxl, tblAuction.pic_diashow, tblAuction.pic_count, tblAuction.item_site_id FROM tblUser INNER JOIN tblAuction ON tblUser.id = tblAuction.seller_id; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJoshxtothe4
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POvbscript to export an access query to a tab delimited file not working
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POvbscript to export an access query to a tab delimited file not working
      1. USKeesDijk
      1. VTFavorite
    3. VO
      singulars
      1. POvbscript to export an access query to a tab delimited file not working
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHumm, it works on my machine, windows XP with visual studio 2005 and MS access 2000 installed, no problem. Could you give more detail on your configuration ? Does your query work in access self ? Can you get it to work for a new table you define ? (with a few simple columns)
      singulars
      1. POvbscript to export an access query to a tab delimited file not working
      1. USKeesDijk
    2. COThis relates to http://stackoverflow.com/questions/280894/automatically-convert-access-db, and as was mentioned in that thread, if you cannot export from Access, there is some major problem. Are you using pure MS Access or do you have a different back-end?
      singulars
      1. POvbscript to export an access query to a tab delimited file not working
      1. USFionnuala
    3. COI am using Pure access 2003. The error I get running a TransferText macro in access is error 3001, and error 80040e37 when trying to run the vbscript.
      singulars
      1. POvbscript to export an access query to a tab delimited file not working
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload