schema.ini created automatically by access

[arnold]

I was exporting/importing data from Access 2002 tables to txt files once
and schema.ini file was created automatically in the same directory with table.txt
Now I can not remember how it happened - I would like to have shema.ini.

Could you please remind me how to do it.

Thanks.

 

['69 Camaro]

Hi, Arnold.

The Schema.ini file is not generated automatically. This must have been a
custom procedure created by your database developer to import/export data
from your database application.

You can find the information about and specifications for creating your own
Schema.ini file on the following Web page:

http://msdn.microsoft.com/library/d.../en-us/office97/html/workingwithtextfiles.asp

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that
a message will be forwarded to me. Spammers who use my UNALTERED
reply E-mail address will only satisfy the SpamEater's hunger.)

 

[John Nurick]

Hi Arnold,

AFAIK schema.ini is created if you choose "Microsoft Word Merge" format
but not otherwise.

 

['69 Camaro]

Thanks, John! I didn't know that about using Word.

Gunny

 

[david epsom dot com dot au]

If you use a create table query to create a text file,
you will normally get a schema.ini file to go with it:

"SELECT tblfx_audit.* INTO [Text;DATABASE=c:\].[mytext.txt]
FROM [tblfx_audit]"

(david)