Re: Load from file using asterisk as field delimiter

Hi again,

Dan Rock wrote:

> Below is my VBA code which imports the file.
> The magic appears to be in the line :
>
> DoCmd.TransferText acImportDelim, "spc823_ProductCatalog",
> "tblB2B_823_TEMP", strFileName, False, ""
>
> MS Access allows me to create an "Import Specification" where I can
> set up the field delimiters, etc.
>
> It simply grabs the text file and then imports the data into the temp
> table. Takes about 10 seconds for the table to be populated.

my VBA and Access knowledges are very limited. Is that TransferText a
stored procedure or an MS Access command?

>
> By the way, I am using an Advantage Database server for my database.

you still haven't said which data access components you use. That's a
totally different thing from which database you use

--
Best regards :)

Guillem Vicens
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
in order to contact me remove the -nospam
.

Relevant Pages

  • Re: Load from file using asterisk as field delimiter
    ... Import Specification is an MS Access command. ... >> Below is my VBA code which imports the file. ... I am using an Advantage Database server for my database. ... > you still haven't said which data access components you use. ...
    (borland.public.delphi.database.ado)
  • RE: Cant delete table "You do not have the necessary permisions to us
    ... I was able to create a SQL Data Definition query for each of the tables I ... opens, it imports three tables from a user-level secured backend database, ... I am using the database as the database owner and I (and all the Full Data ... Permissions dialogue box. ...
    (microsoft.public.access.security)
  • Re: db repair
    ... Server. ... VB Script looks amazingly like VBA, since they're both based upon the same ... See http://www.mvps.org/access/general/gen0041.htm for the VBA code to ... this won't compact the database ...
    (microsoft.public.access.setupconfig)
  • Re: Web part is empty (code taken directly out of book)
    ... > I am using the Microsoft SharePoint Building Office 2003 Solutions book ... > sample database. ... > Imports System.ComponentModel ... Private strSQLserver As String = "" ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: MultiValue Field
    ... provide data both for our office use and for the home office. ... I can add fields to the big database, up to a limit, but I want to use the ... the code that imports the data. ... Categories with a junction table (ContactCategories) with foreign keys to ...
    (microsoft.public.access.tablesdbdesign)