schema.ini

[Sor_man]

Can someone pls help me. Whats wrong in these lines. Tried many things but
can't get it to work.

DoCmd.TransferText acExportFixed,
"[c:\Bonappetit\udviklingsapplikation\schema.ini]", "[Kunde_Scan_Eksport]",
"[c:\Bonappetit\udviklingsapplikation\Kunde.txt]", False

My schema.ini file looks like this
[Kunde.txt]
ColNameHeader = True
CharacterSet = ANSI
Format = FixedLength
Col1=KundeId char width 10
Col2=Kundenavn Char Width 89

Thanks
Sor_man

 

[Douglas J. Steele]

The square brackets around the file names are incorrect.

 

[John Nurick]

In addition to Doug's comment: The second argument of TransferText is
for an export specification. If you're using schema.ini you must (as far
as I know) omit this argument; the export routine automatically searches
for schema.ini in the destination folder.

As the code stands you're telling TransferText to use an export
specification called
[c:\Bonappetit\udviklingsapplikation\schema.ini]

Can someone pls help me. Whats wrong in these lines. Tried many things but
can't get it to work.

DoCmd.TransferText acExportFixed,
"[c:\Bonappetit\udviklingsapplikation\schema.ini]", "[Kunde_Scan_Eksport]",
"[c:\Bonappetit\udviklingsapplikation\Kunde.txt]", False

My schema.ini file looks like this
[Kunde.txt]
ColNameHeader = True
CharacterSet = ANSI
Format = FixedLength
Col1=KundeId char width 10
Col2=Kundenavn Char Width 89

Thanks
Sor_man

 

[david epsom dot com dot au]

Also, there was an old Jet bug that caused a problem with this:
make sure you have downloaded the latest version of Jet 4.0

 

[david epsom dot com dot au]

or is that an unfixed bug in Access 2000?

http://support.microsoft.com/kb/Q241477
ACC2000: Error When You Try to Use Schema.ini to Import or Export with the
TransferText Method

(david)

Also, there was an old Jet bug that caused a problem with this:
make sure you have downloaded the latest version of Jet 4.0

Can someone pls help me. Whats wrong in these lines. Tried many things but
can't get it to work.

DoCmd.TransferText acExportFixed,
"[c:\Bonappetit\udviklingsapplikation\schema.ini]", "[Kunde_Scan_Eksport]",
"[c:\Bonappetit\udviklingsapplikation\Kunde.txt]", False

My schema.ini file looks like this
[Kunde.txt]
ColNameHeader = True
CharacterSet = ANSI
Format = FixedLength
Col1=KundeId char width 10
Col2=Kundenavn Char Width 89

Thanks
Sor_man

 

[sor_man]

Hi David,
Thanks for answering my question. I think you are right about the error. It
says its not able to finde the file which looks like this "c:Bonappetit
udviklingsapplikation schema.ini" without "/" in the directory info.
I'm running access 2003. Do you know where I can update to jet 4.0 and will
it work ?

Thanks for taking the time..


"david epsom dot com dot au" skrev:

or is that an unfixed bug in Access 2000?

http://support.microsoft.com/kb/Q241477
ACC2000: Error When You Try to Use Schema.ini to Import or Export with the
TransferText Method

(david)

Also, there was an old Jet bug that caused a problem with this:
make sure you have downloaded the latest version of Jet 4.0

Can someone pls help me. Whats wrong in these lines. Tried many things but
can't get it to work.

DoCmd.TransferText acExportFixed,
"[c:\Bonappetit\udviklingsapplikation\schema.ini]", "[Kunde_Scan_Eksport]",
"[c:\Bonappetit\udviklingsapplikation\Kunde.txt]", False

My schema.ini file looks like this
[Kunde.txt]
ColNameHeader = True
CharacterSet = ANSI
Format = FixedLength
Col1=KundeId char width 10
Col2=Kundenavn Char Width 89

Thanks
Sor_man

 

[david epsom dot com dot au]

For text files, Schema.ini should be in the same folder
as the text file. You should leave the export specification
blank.

I thought that Access 2000 bug in TransferText should have
been fixed by now: If you are still having a problem, you
should probably use the ADO/DAO SQL method demonstrated in
that article.

(david)

Hi David,
Thanks for answering my question. I think you are right about the error. It
says its not able to finde the file which looks like this "c:Bonappetit
udviklingsapplikation schema.ini" without "/" in the directory info.
I'm running access 2003. Do you know where I can update to jet 4.0 and will
it work ?

Thanks for taking the time..


"david epsom dot com dot au" skrev:

or is that an unfixed bug in Access 2000?

http://support.microsoft.com/kb/Q241477
ACC2000: Error When You Try to Use Schema.ini to Import or Export with the
TransferText Method

(david)

Also, there was an old Jet bug that caused a problem with this:
make sure you have downloaded the latest version of Jet 4.0


Can someone pls help me. Whats wrong in these lines. Tried many

things
but

can't get it to work.

DoCmd.TransferText acExportFixed,
"[c:\Bonappetit\udviklingsapplikation\schema.ini]",
"[Kunde_Scan_Eksport]",
"[c:\Bonappetit\udviklingsapplikation\Kunde.txt]", False

My schema.ini file looks like this
[Kunde.txt]
ColNameHeader = True
CharacterSet = ANSI
Format = FixedLength
Col1=KundeId char width 10
Col2=Kundenavn Char Width 89

Thanks
Sor_man

 

[sor_man]

Hi again,

I'm still having the problems. Unfortunately the ADO/DAO SQL method only
demonstrates a text import function and I need an export function. Do you by
any chance have an exampel of an export function ?
That would be really helpfull.

"david epsom dot com dot au" skrev:

For text files, Schema.ini should be in the same folder
as the text file. You should leave the export specification
blank.

I thought that Access 2000 bug in TransferText should have
been fixed by now: If you are still having a problem, you
should probably use the ADO/DAO SQL method demonstrated in
that article.

(david)

Hi David,
Thanks for answering my question. I think you are right about the error. It
says its not able to finde the file which looks like this "c:Bonappetit
udviklingsapplikation schema.ini" without "/" in the directory info.
I'm running access 2003. Do you know where I can update to jet 4.0 and will
it work ?

Thanks for taking the time..


"david epsom dot com dot au" skrev:

or is that an unfixed bug in Access 2000?

http://support.microsoft.com/kb/Q241477
ACC2000: Error When You Try to Use Schema.ini to Import or Export with the
TransferText Method

(david)


Also, there was an old Jet bug that caused a problem with this:
make sure you have downloaded the latest version of Jet 4.0


Can someone pls help me. Whats wrong in these lines. Tried many things
but
can't get it to work.

DoCmd.TransferText acExportFixed,
"[c:\Bonappetit\udviklingsapplikation\schema.ini]",
"[Kunde_Scan_Eksport]",
"[c:\Bonappetit\udviklingsapplikation\Kunde.txt]", False

My schema.ini file looks like this
[Kunde.txt]
ColNameHeader = True
CharacterSet = ANSI
Format = FixedLength
Col1=KundeId char width 10
Col2=Kundenavn Char Width 89

Thanks
Sor_man

 

[david epsom dot com dot au]

You can use either an append or an update query, depending on what you are
trying to do. The full format of a data source or destination is
[database].[TableOrQueryName], so the example can be rewritten to run the
other way:


"SELECT * INTO NewContact FROM [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\My
documents;].[Contacts#txt];",

"SELECT * INTO [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\My
documents;].[Contacts#txt] FROM NewContact;"


(david)