Re: Problem using schema.ini

From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 07:09:33 +0000

Hi Keith,

Schema.ini must be in the same folder as the file you're importing, and
there must be an entry in schema.ini for the particular file (or rather
filename). Each entry looks somewhat like this:

[MyData.txt]
ColNameHeader=True
CharacterSet=1252
Format=TabDelimited
Col1=ID Integer
Col2=Firstname Char Width 50
Col3=Lastname Char Width 50
Col4=Street Char Width 60
Col5=City Char Width 40
Col6=Postcode Char Width 14
Col7=NumberNum Integer
Col8=Comment Char Width 255
Col9=Checked Bit

On Thu, 26 Feb 2004 13:08:21 -0800, "keith"
<anonymous@discussions.microsoft.com> wrote:

>Hello,
>
>I created a test filel with data, and named it MyData.txt
>I then created a schema.ini file with the layout of the
>filel as describee in Microsoft on-line help file
>odbcjetsdk_98.asp I created a new mdb file where the test
>data will reside. Now, I'm having difficulty using the
>schema file to get the data from MyData.txt into the new
>mdb file. I used File-->Get External Data --> Import -->
>select txt file --> select MyData.txt and the form does
>not include the formats in the schema.ini file and does
>not give me any option under "Advanced" to identify the
>schema.ini file. So obviously I'm still doing something
>wrong. I hope this explanation is sufficient, and look
>forward to any suggestions.
>
>Thank you,
>
>Keith 

--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.

Relevant Pages

  • [RFC] [Patch 4/4] timer_stats slimmed down: using statistics infrastucture
    ... (>80 char lines because of symbol names, ... * tstat entry structs only get allocated while collection is ... -static void reset_entries ... -static struct entry *alloc_entry ...
    (Linux-Kernel)
  • Re: what is the meaning of "char **option"?
    ... address of a location that holds the address of a location of a char. ... *option points to the first entry of the choices array, ... long as the entry is not NULL ... i compile it by GCC 4 on ArchLinux ...
    (comp.lang.c)
  • Re: why I cant input chars in the entryfield ?
    ... proc check_code {entry char} { ... Here my proc check_code is to insure the input is like "sz000063", ... checking is based on the current widget state (i.e. you aren't ... looking at what adding the new char does. ...
    (comp.lang.tcl)
  • Re: Problem using schema.ini
    ... >Hi Keith, ... Each entry looks somewhat like this: ... >Col2=Firstname Char Width 50 ... >>I created a test filel with data, ...
    (microsoft.public.access.externaldata)
  • Re: System.Text.RegularExpressions sintaxis
    ... it find any char & or % or | ... /// The main entry point for the application. ... [STAThread] ... static void Main ...
    (microsoft.public.dotnet.languages.csharp)
Quantcast