Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Error accessing data in Proxy table located in a .csv file

5 posts in General Discussion Last posting was on 2008-01-08 17:26:13.0Z
Dave Westphal Posted on 2007-12-24 17:32:15.0Z
From: "Dave Westphal" <Dave_Westphal@aal.org>
Newsgroups: ianywhere.public.general
Subject: Error accessing data in Proxy table located in a .csv file
Lines: 22
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: xbonat.thrivent.com
X-Original-NNTP-Posting-Host: xbonat.thrivent.com
Message-ID: <476fed1f@forums-1-dub>
Date: 24 Dec 2007 09:32:15 -0800
X-Trace: forums-1-dub 1198517535 64.214.85.60 (24 Dec 2007 09:32:15 -0800)
X-Original-Trace: 24 Dec 2007 09:32:15 -0800, xbonat.thrivent.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6651
Article PK: 4899

ASA 9.0.2 build 3486

I set up an ODBC entry to access a .csv file.
I went into SQL Central and was able to configure a remote server and create
a new Proxy table ( SF_RecordType ). The first line of the .csv file was
read in and the proxy table appears to have the 4 columns found in the .csv
file.

When I try to query the proxy table I get an error:
Server 'SF_T XT': [Microsoft][ODBC Text Driver] The Microsoft Jet database
engine could not find the object
'c:\staging\data\dataloader\SF\data\recordtype.csv'. Make sure the object
exists and that you spell its name and
the path name correctly.

Is anyone familiar withe setting up a Proxy table to access data in a .csv
file?

Thanks in Advance,
Dave


Dietrich Posted on 2007-12-27 13:14:27.0Z
From: Dietrich <Dietrich@iAnywhere.Sybase.Germany>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Error accessing data in Proxy table located in a .csv file
References: <476fed1f@forums-1-dub>
In-Reply-To: <476fed1f@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: dlauterxp.sybase.com
X-Original-NNTP-Posting-Host: dlauterxp.sybase.com
Message-ID: <4773a533$1@forums-1-dub>
Date: 27 Dec 2007 05:14:27 -0800
X-Trace: forums-1-dub 1198761267 10.56.33.201 (27 Dec 2007 05:14:27 -0800)
X-Original-Trace: 27 Dec 2007 05:14:27 -0800, dlauterxp.sybase.com
Lines: 101
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6652
Article PK: 4901

Hi Dave,

I did a short test with a proxy table based on a csv file.
It was working!
See the sample below. Isn't beautiful, but shows what I've done.

Test environment:
ASA 9.0.2 EBF 3486 on WinXP (english) with Regional Setting: Germany
Microsoft Text Driver (*.txt; *.csv) 4.00.6304.0
EXCEL 2003


Kind regards,

Dietrich


=== SAMPLE ===

1.) CSV-File
- navigate to the folder where the csv-file should be placed in e.g.
"D:\My Documents\SQL Anywhere\Proxy Table CVS"
- create a new text file "test.csv" the with the following three lines
AAA;111
BBB;222
CCC;333


2.) ODBC-Source
- create a new ODBC data source
+ select the driver "Microsoft Text Driver (*.txt; *.csv)"
+ set the data source name to "PT_CSV"
+ choose the directory, where the csv-file is stored e.g. "D:\My
Documents\SQL Anywhere\Proxy Table CVS"
+ uncheck the "Default (*.*)" to allow only the following extentions:
*. *.asc *.csv *.tab *.txt
- "Define Format..." for this new data source
+ select table "test.csv"
+ choose format "Custom Delimited" with the delimiter ";"
+ add the column "COLSTR" with the data type "LongChar"
+ add the column "COLINT" with the data type "Integer"
=> in result a file schema.ini has been created in the directory where
the csv-file is stored
[test.csv]
ColNameHeader=False
Format=Delimited(;)
MaxScanRows=25
CharacterSet=OEM
Col1=COLSTR LongChar
Col2=COLINT Integer


3.) Test using EXCEL
- create an empty spread sheet
- choose menu Data > Import External Data > New Database Query...
- select database "PT_CSV" and click "OK"
- add the columns COLSTR and COLINT to the list of "Columns in your query"
- navigate through the following dialogs of the Query Wizard and click
on "Finish"
- confirm the "Import Data" dialog by a click on "OK"
=> column names and data rows are correctly inserted into the sheet
=> Test successful


4.) Test using dbisqlc
- make sure the database is running (using for example "dbsrv9.exe
asademo.db")
- start dbisqlc and connect to the database
- run the following two statements to create the proxy table
CREATE SERVER RemoteCSV CLASS 'ODBC' USING 'PT_CSV';
CREATE EXISTING TABLE Rtest AT 'RemoteCSV;;;test.csv';
- run a simple select statement to check the proxy table e.g. using the
following command
SELECT * FROM Rtest;
=> column names and data rows are shown correctly
=> Test successful

Dave Westphal wrote:
> ASA 9.0.2 build 3486
>
> I set up an ODBC entry to access a .csv file.
> I went into SQL Central and was able to configure a remote server and create
> a new Proxy table ( SF_RecordType ). The first line of the .csv file was
> read in and the proxy table appears to have the 4 columns found in the .csv
> file.
>
> When I try to query the proxy table I get an error:
> Server 'SF_T XT': [Microsoft][ODBC Text Driver] The Microsoft Jet database
> engine could not find the object
> 'c:\staging\data\dataloader\SF\data\recordtype.csv'. Make sure the object
> exists and that you spell its name and
> the path name correctly.
>
> Is anyone familiar withe setting up a Proxy table to access data in a .csv
> file?
>
> Thanks in Advance,
> Dave
>
>


Dave Westphal Posted on 2008-01-02 21:52:47.0Z
From: "Dave Westphal" <Dave_Westphal@aal.org>
Newsgroups: ianywhere.public.general
References: <476fed1f@forums-1-dub> <4773a533$1@forums-1-dub>
Subject: Re: Error accessing data in Proxy table located in a .csv file
Lines: 117
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: xbonat.thrivent.com
X-Original-NNTP-Posting-Host: xbonat.thrivent.com
Message-ID: <477c07af$1@forums-1-dub>
Date: 2 Jan 2008 13:52:47 -0800
X-Trace: forums-1-dub 1199310767 64.214.85.60 (2 Jan 2008 13:52:47 -0800)
X-Original-Trace: 2 Jan 2008 13:52:47 -0800, xbonat.thrivent.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6660
Article PK: 4909

Thanks for your response.
I have gone back to see what step I may have missed.
The only thing that I see is that I have my csv file delimited by ',' not
';'. in dbisqlc I query my table and I get the proper Column headings, but
I continue to get an error in dbisqlc "The Microsoft Jet database engine
could not find the object" followed by the path to my csv file. "Make sure
the object exists and that you spell its name and the path name correctly."

Getting the column names in, I am guessing that the path and file are
correct. I never typed them, I picked them in the dialog boxes in the ODBC
Admin.
Any ideas on why the object not found error would come up?

"Dietrich" <Dietrich@iAnywhere.Sybase.Germany> wrote in message
news:4773a533$1@forums-1-dub...
> Hi Dave,
>
> I did a short test with a proxy table based on a csv file.
> It was working!
> See the sample below. Isn't beautiful, but shows what I've done.
>
> Test environment:
> ASA 9.0.2 EBF 3486 on WinXP (english) with Regional Setting: Germany
> Microsoft Text Driver (*.txt; *.csv) 4.00.6304.0
> EXCEL 2003
>
>
> Kind regards,
>
> Dietrich
>
>
> === SAMPLE ===
>
> 1.) CSV-File
> - navigate to the folder where the csv-file should be placed in e.g.
> "D:\My Documents\SQL Anywhere\Proxy Table CVS"
> - create a new text file "test.csv" the with the following three lines
> AAA;111
> BBB;222
> CCC;333
>
>
> 2.) ODBC-Source
> - create a new ODBC data source
> + select the driver "Microsoft Text Driver (*.txt; *.csv)"
> + set the data source name to "PT_CSV"
> + choose the directory, where the csv-file is stored e.g. "D:\My
> Documents\SQL Anywhere\Proxy Table CVS"
> + uncheck the "Default (*.*)" to allow only the following extentions: *.
> *.asc *.csv *.tab *.txt
> - "Define Format..." for this new data source
> + select table "test.csv"
> + choose format "Custom Delimited" with the delimiter ";"
> + add the column "COLSTR" with the data type "LongChar"
> + add the column "COLINT" with the data type "Integer"
> => in result a file schema.ini has been created in the directory where the
> csv-file is stored
> [test.csv]
> ColNameHeader=False
> Format=Delimited(;)
> MaxScanRows=25
> CharacterSet=OEM
> Col1=COLSTR LongChar
> Col2=COLINT Integer
>
>
> 3.) Test using EXCEL
> - create an empty spread sheet
> - choose menu Data > Import External Data > New Database Query...
> - select database "PT_CSV" and click "OK"
> - add the columns COLSTR and COLINT to the list of "Columns in your query"
> - navigate through the following dialogs of the Query Wizard and click on
> "Finish"
> - confirm the "Import Data" dialog by a click on "OK"
> => column names and data rows are correctly inserted into the sheet
> => Test successful
>
>
> 4.) Test using dbisqlc
> - make sure the database is running (using for example "dbsrv9.exe
> asademo.db")
> - start dbisqlc and connect to the database
> - run the following two statements to create the proxy table
> CREATE SERVER RemoteCSV CLASS 'ODBC' USING 'PT_CSV';
> CREATE EXISTING TABLE Rtest AT 'RemoteCSV;;;test.csv';
> - run a simple select statement to check the proxy table e.g. using the
> following command
> SELECT * FROM Rtest;
> => column names and data rows are shown correctly
> => Test successful
>
>
> Dave Westphal wrote:
>> ASA 9.0.2 build 3486
>>
>> I set up an ODBC entry to access a .csv file.
>> I went into SQL Central and was able to configure a remote server and
>> create a new Proxy table ( SF_RecordType ). The first line of the .csv
>> file was read in and the proxy table appears to have the 4 columns found
>> in the .csv file.
>>
>> When I try to query the proxy table I get an error:
>> Server 'SF_T XT': [Microsoft][ODBC Text Driver] The Microsoft Jet
>> database engine could not find the object
>> 'c:\staging\data\dataloader\SF\data\recordtype.csv'. Make sure the
>> object exists and that you spell its name and
>> the path name correctly.
>>
>> Is anyone familiar withe setting up a Proxy table to access data in a
>> .csv file?
>>
>> Thanks in Advance,
>> Dave


Dietrich Posted on 2008-01-03 16:34:06.0Z
From: Dietrich <Dietrich@iAnywhere.Sybase.Germany>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Error accessing data in Proxy table located in a .csv file
References: <476fed1f@forums-1-dub> <4773a533$1@forums-1-dub> <477c07af$1@forums-1-dub>
In-Reply-To: <477c07af$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: dlauterxp.sybase.com
X-Original-NNTP-Posting-Host: dlauterxp.sybase.com
Message-ID: <477d0e7e$1@forums-1-dub>
Date: 3 Jan 2008 08:34:06 -0800
X-Trace: forums-1-dub 1199378046 10.56.33.201 (3 Jan 2008 08:34:06 -0800)
X-Original-Trace: 3 Jan 2008 08:34:06 -0800, dlauterxp.sybase.com
Lines: 143
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6663
Article PK: 4914

Hi Dave,

I do not expect that the "," is the cause of your problem. But the best
would be to test it and change the delimiter to ";" and change the
definition in the DSN.
I couldn't use the "," as delimiter, because that conflicts with the
decimal separator (Regional Setting: German).

Have you run a test using a different application, like I did in the 3rd
step?

What do you mean by "I get the proper Column headings"? I hope you are
referring to the normal column header in dbisqlc that you see n result
of every select statement.

Do you have column header in the csv file? If so,

Maybe you could run the steps that I did and see if at least this sample
works. If so, you could try to adapt the sample more and more to the
scenario you are planning to use.

Kind regards,

Dietrich

Dave Westphal wrote:
> Thanks for your response.
> I have gone back to see what step I may have missed.
> The only thing that I see is that I have my csv file delimited by ',' not
> ';'. in dbisqlc I query my table and I get the proper Column headings, but
> I continue to get an error in dbisqlc "The Microsoft Jet database engine
> could not find the object" followed by the path to my csv file. "Make sure
> the object exists and that you spell its name and the path name correctly."
>
> Getting the column names in, I am guessing that the path and file are
> correct. I never typed them, I picked them in the dialog boxes in the ODBC
> Admin.
> Any ideas on why the object not found error would come up?
>
>
> "Dietrich" <Dietrich@iAnywhere.Sybase.Germany> wrote in message
> news:4773a533$1@forums-1-dub...
>> Hi Dave,
>>
>> I did a short test with a proxy table based on a csv file.
>> It was working!
>> See the sample below. Isn't beautiful, but shows what I've done.
>>
>> Test environment:
>> ASA 9.0.2 EBF 3486 on WinXP (english) with Regional Setting: Germany
>> Microsoft Text Driver (*.txt; *.csv) 4.00.6304.0
>> EXCEL 2003
>>
>>
>> Kind regards,
>>
>> Dietrich
>>
>>
>> === SAMPLE ===
>>
>> 1.) CSV-File
>> - navigate to the folder where the csv-file should be placed in e.g.
>> "D:\My Documents\SQL Anywhere\Proxy Table CVS"
>> - create a new text file "test.csv" the with the following three lines
>> AAA;111
>> BBB;222
>> CCC;333
>>
>>
>> 2.) ODBC-Source
>> - create a new ODBC data source
>> + select the driver "Microsoft Text Driver (*.txt; *.csv)"
>> + set the data source name to "PT_CSV"
>> + choose the directory, where the csv-file is stored e.g. "D:\My
>> Documents\SQL Anywhere\Proxy Table CVS"
>> + uncheck the "Default (*.*)" to allow only the following extentions: *.
>> *.asc *.csv *.tab *.txt
>> - "Define Format..." for this new data source
>> + select table "test.csv"
>> + choose format "Custom Delimited" with the delimiter ";"
>> + add the column "COLSTR" with the data type "LongChar"
>> + add the column "COLINT" with the data type "Integer"
>> => in result a file schema.ini has been created in the directory where the
>> csv-file is stored
>> [test.csv]
>> ColNameHeader=False
>> Format=Delimited(;)
>> MaxScanRows=25
>> CharacterSet=OEM
>> Col1=COLSTR LongChar
>> Col2=COLINT Integer
>>
>>
>> 3.) Test using EXCEL
>> - create an empty spread sheet
>> - choose menu Data > Import External Data > New Database Query...
>> - select database "PT_CSV" and click "OK"
>> - add the columns COLSTR and COLINT to the list of "Columns in your query"
>> - navigate through the following dialogs of the Query Wizard and click on
>> "Finish"
>> - confirm the "Import Data" dialog by a click on "OK"
>> => column names and data rows are correctly inserted into the sheet
>> => Test successful
>>
>>
>> 4.) Test using dbisqlc
>> - make sure the database is running (using for example "dbsrv9.exe
>> asademo.db")
>> - start dbisqlc and connect to the database
>> - run the following two statements to create the proxy table
>> CREATE SERVER RemoteCSV CLASS 'ODBC' USING 'PT_CSV';
>> CREATE EXISTING TABLE Rtest AT 'RemoteCSV;;;test.csv';
>> - run a simple select statement to check the proxy table e.g. using the
>> following command
>> SELECT * FROM Rtest;
>> => column names and data rows are shown correctly
>> => Test successful
>>
>>
>> Dave Westphal wrote:
>>> ASA 9.0.2 build 3486
>>>
>>> I set up an ODBC entry to access a .csv file.
>>> I went into SQL Central and was able to configure a remote server and
>>> create a new Proxy table ( SF_RecordType ). The first line of the .csv
>>> file was read in and the proxy table appears to have the 4 columns found
>>> in the .csv file.
>>>
>>> When I try to query the proxy table I get an error:
>>> Server 'SF_T XT': [Microsoft][ODBC Text Driver] The Microsoft Jet
>>> database engine could not find the object
>>> 'c:\staging\data\dataloader\SF\data\recordtype.csv'. Make sure the
>>> object exists and that you spell its name and
>>> the path name correctly.
>>>
>>> Is anyone familiar withe setting up a Proxy table to access data in a
>>> .csv file?
>>>
>>> Thanks in Advance,
>>> Dave
>
>


"Stephen Rice" Posted on 2008-01-08 17:26:13.0Z
From: "Stephen Rice" <srice[at]sybase[dot]com>
Newsgroups: ianywhere.public.general
References: <476fed1f@forums-1-dub> <4773a533$1@forums-1-dub> <477c07af$1@forums-1-dub> <477d0e7e$1@forums-1-dub>
Subject: Re: Error accessing data in Proxy table located in a .csv file
Lines: 155
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: srice-pciii.sybase.com
X-Original-NNTP-Posting-Host: srice-pciii.sybase.com
Message-ID: <4783b235@forums-1-dub>
Date: 8 Jan 2008 09:26:13 -0800
X-Trace: forums-1-dub 1199813173 10.25.98.116 (8 Jan 2008 09:26:13 -0800)
X-Original-Trace: 8 Jan 2008 09:26:13 -0800, srice-pciii.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6668
Article PK: 4917

Try set option cis_option=7
and/or taking an ODBC trace to set what is upsetting the Jet engine

--
/steve
Stephen Rice
Sybase iAnywhere

"Dietrich" <Dietrich@iAnywhere.Sybase.Germany> wrote in message
news:477d0e7e$1@forums-1-dub...
> Hi Dave,
>
> I do not expect that the "," is the cause of your problem. But the best
> would be to test it and change the delimiter to ";" and change the
> definition in the DSN.
> I couldn't use the "," as delimiter, because that conflicts with the
> decimal separator (Regional Setting: German).
>
> Have you run a test using a different application, like I did in the 3rd
> step?
>
> What do you mean by "I get the proper Column headings"? I hope you are
> referring to the normal column header in dbisqlc that you see n result of
> every select statement.
>
> Do you have column header in the csv file? If so,
>
> Maybe you could run the steps that I did and see if at least this sample
> works. If so, you could try to adapt the sample more and more to the
> scenario you are planning to use.
>
> Kind regards,
>
> Dietrich
>
> Dave Westphal wrote:
>> Thanks for your response.
>> I have gone back to see what step I may have missed.
>> The only thing that I see is that I have my csv file delimited by ',' not
>> ';'. in dbisqlc I query my table and I get the proper Column headings,
>> but I continue to get an error in dbisqlc "The Microsoft Jet database
>> engine could not find the object" followed by the path to my csv file.
>> "Make sure the object exists and that you spell its name and the path
>> name correctly."
>>
>> Getting the column names in, I am guessing that the path and file are
>> correct. I never typed them, I picked them in the dialog boxes in the
>> ODBC Admin.
>> Any ideas on why the object not found error would come up?
>>
>>
>> "Dietrich" <Dietrich@iAnywhere.Sybase.Germany> wrote in message
>> news:4773a533$1@forums-1-dub...
>>> Hi Dave,
>>>
>>> I did a short test with a proxy table based on a csv file.
>>> It was working!
>>> See the sample below. Isn't beautiful, but shows what I've done.
>>>
>>> Test environment:
>>> ASA 9.0.2 EBF 3486 on WinXP (english) with Regional Setting: Germany
>>> Microsoft Text Driver (*.txt; *.csv) 4.00.6304.0
>>> EXCEL 2003
>>>
>>>
>>> Kind regards,
>>>
>>> Dietrich
>>>
>>>
>>> === SAMPLE ===
>>>
>>> 1.) CSV-File
>>> - navigate to the folder where the csv-file should be placed in e.g.
>>> "D:\My Documents\SQL Anywhere\Proxy Table CVS"
>>> - create a new text file "test.csv" the with the following three lines
>>> AAA;111
>>> BBB;222
>>> CCC;333
>>>
>>>
>>> 2.) ODBC-Source
>>> - create a new ODBC data source
>>> + select the driver "Microsoft Text Driver (*.txt; *.csv)"
>>> + set the data source name to "PT_CSV"
>>> + choose the directory, where the csv-file is stored e.g. "D:\My
>>> Documents\SQL Anywhere\Proxy Table CVS"
>>> + uncheck the "Default (*.*)" to allow only the following extentions:
>>> *. *.asc *.csv *.tab *.txt
>>> - "Define Format..." for this new data source
>>> + select table "test.csv"
>>> + choose format "Custom Delimited" with the delimiter ";"
>>> + add the column "COLSTR" with the data type "LongChar"
>>> + add the column "COLINT" with the data type "Integer"
>>> => in result a file schema.ini has been created in the directory where
>>> the csv-file is stored
>>> [test.csv]
>>> ColNameHeader=False
>>> Format=Delimited(;)
>>> MaxScanRows=25
>>> CharacterSet=OEM
>>> Col1=COLSTR LongChar
>>> Col2=COLINT Integer
>>>
>>>
>>> 3.) Test using EXCEL
>>> - create an empty spread sheet
>>> - choose menu Data > Import External Data > New Database Query...
>>> - select database "PT_CSV" and click "OK"
>>> - add the columns COLSTR and COLINT to the list of "Columns in your
>>> query"
>>> - navigate through the following dialogs of the Query Wizard and click
>>> on "Finish"
>>> - confirm the "Import Data" dialog by a click on "OK"
>>> => column names and data rows are correctly inserted into the sheet
>>> => Test successful
>>>
>>>
>>> 4.) Test using dbisqlc
>>> - make sure the database is running (using for example "dbsrv9.exe
>>> asademo.db")
>>> - start dbisqlc and connect to the database
>>> - run the following two statements to create the proxy table
>>> CREATE SERVER RemoteCSV CLASS 'ODBC' USING 'PT_CSV';
>>> CREATE EXISTING TABLE Rtest AT 'RemoteCSV;;;test.csv';
>>> - run a simple select statement to check the proxy table e.g. using the
>>> following command
>>> SELECT * FROM Rtest;
>>> => column names and data rows are shown correctly
>>> => Test successful
>>>
>>>
>>> Dave Westphal wrote:
>>>> ASA 9.0.2 build 3486
>>>>
>>>> I set up an ODBC entry to access a .csv file.
>>>> I went into SQL Central and was able to configure a remote server and
>>>> create a new Proxy table ( SF_RecordType ). The first line of the .csv
>>>> file was read in and the proxy table appears to have the 4 columns
>>>> found in the .csv file.
>>>>
>>>> When I try to query the proxy table I get an error:
>>>> Server 'SF_T XT': [Microsoft][ODBC Text Driver] The Microsoft Jet
>>>> database engine could not find the object
>>>> 'c:\staging\data\dataloader\SF\data\recordtype.csv'. Make sure the
>>>> object exists and that you spell its name and
>>>> the path name correctly.
>>>>
>>>> Is anyone familiar withe setting up a Proxy table to access data in a
>>>> .csv file?
>>>>
>>>> Thanks in Advance,
>>>> Dave
>>