Need to find out how to make "schema.ini". 2

[THOMASNG]

I already have a database, "CCRTable1" in ACCESS 2000. I can manipulate it directly via ADODC and a .vbp on a second computer.
I would now like to fully automate the creation of two
ASCII (plain text files), "OWNER.TXT" and "CONTAINER.TXT", using the volume of data stored in CCRTable1.
I already have created two queries, "OwnerTxtCCRTable1" and "ContainerTxtCCRTable1". I've used these two queries to partially ease the tasks, but it's still a quite a bear!
I think I could finish this if I got clear instructions
on how to create "schema.ini" for each of these files.

 

[vb5prgrmr]

So what you are saying is you want to take the data in the database and create text files with that data.

1. Open Datebase, Recordset, and Output Text File.
2. Loop through recordset until EOF Writting to text file
3. Close Text File, Recordset, and Database.

Good Luck

 

[johnwm]

There is some notes on schema.ini here:

http://www.experts-exchange.com/Databases/Q_20400401.html

There was some stuff on MSDN, but it seems to be down at present:

http://msdn.microsoft.com/library/d...ry/en-us/odbc/htm/odbcjettext_file_format.asp

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[CCLINT]

The JET provider works also well for this.
You would need to supply an Schema.Ini in the output folder in order to override the default registry settings (delimiter, etc.)

Use a SELECT INTO action query for this.

See thread709-334828 for the Schema.Ini [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[CCLINT]

Dim conn As ADODB.Connection
set conn=Adodc1.Recordset.ActiveConnection

conn.Execute "SELECT dbField1 AS txtField1,dbField2 AS txtField2 " _
& "INTO [OWNER.TXT] " _
& "IN '' [TEXT;DATABASE=C:\Temp\;] " _
& "FROM CCRTable1 " _
& "WHERE dbField1 = 'ABC'"
[/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[THOMASNG]

To clarify:

OWNER.TXT and CONTAINER.TXT will contain only a portion
of the information stored in CCRTable1. I know how to transfer the entire table.

 

[THOMASNG]

Johnwm's answer works. MICROSOFT has a separate link -
one that allows you to search. The clearest article I found was "Working with Text Files".
Thanks again, Johnwm!

 

[CCLINT]

> OWNER.TXT and CONTAINER.TXT will contain only a portion
of the information stored in CCRTable1. I know how to transfer the entire table.

Therefore the WHERE clause.


>The clearest article I found was "Working with Text Files".

And that is the link that I directed you to via a link in the next thread.

johnwm: the second link you gave comes up with a page not found.

[/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[johnwm]

Sorry CCLINT, but as I said in my post There was some stuff on MSDN, but it seems to be down at present:

It used to work, but knowing MS it may now be gone forever!
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[THOMASNG]

Yes, the page is still inoperable today, but you can still search for articles on "schema.ini". "Working with Text Files" is near the top of the articles summarized.
CClint deserves another star for keeping us all on our toes.

 

[CCLINT]

Sorry johnwm, I overlooked your mention of the link being down (this time I read too fast ) [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[CCLINT]

Thanks THOMASNG. [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}