schema.ini

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
 
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
 
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)


david epsom dot com dot au said:
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


Sor_man said:
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
Click to expand...
Click to expand...
 
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)


david epsom dot com dot au said:
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


Sor_man said:
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
Click to expand...
Click to expand...
Click to expand...
 
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)

sor_man said:
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)


david epsom dot com dot au said:
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
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)

sor_man said:
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
Click to expand...
Click to expand...
Click to expand...
 
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)
 
Back
Top