Text File Schema - Simple

[mavericc77]

Hello Everyone,
I am having a problem with dreamweaver mx with the schema option. I thought this would be simple but I may be missing something very easy. I am using the jet oledb 4.0 to read a text file. If I do not include a schema it works great expect the file is comma delimited which is how it is suppose to work. The problem is I have currency data with commas so based on microsoft I need to add a schema for the text file. I tried both a fixed length file and a ; delimited file. I put the schema file in the same directory as the schema source file and the raw data. When I click on the advance and add the schema or schema.ini tried both ways and with fixed length or the ; delimited I get text connection successful but then I get unable to retrieve tables from this connection.

The provider string that works is:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\fs01\d\updates\database\;Extended Properties=text;"

Sample Schema.ini file I tried both ways fixed and ;
[name.txt]
Format=Delimited(

and fixed which I prefer the following:
[name.txt]
Format=FixedLength
Col1=First Text Width 12
Col2=Last Text 20
Col3=Amount1 Currency Width 10
Col4=Amount2 Currency Width 10

Thanks for all you help.
Dan

[mavericc77]

Fixed Problem Self
I just added the schema.ini file into that directory, but took out schema on the advance schema location in Dreamweaver. I knew this should of been simple. but did not know how Dreamweaver handled this.
Here is the Schema I used and works great:
[name.txt]
Format=FixedLength
Col1=First Text Width 10
Col2=Last Text Width 20
Col3=Amount1 Text Width 20
Col4=Amount2 Text Width 20