#1  
Old 11th December 2003, 01:00 AM
Srinivasan Iyer
 
Posts: n/a
Default OT - Excel import to NexusDB

I am trying to use BDE2NX to import some excel data. I noticed that unless I
save the excel file as Excel 4.0, I am not able to see any of the excel
tables in the view. This also limits the number of rows to 16K. Is there any
configuration that I can change and use excel 2002 files for import?
Thanks in advance.
Srini.


  #2  
Old 11th December 2003, 03:18 AM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: OT - Excel import to NexusDB

> I am trying to use BDE2NX to import some excel data. I noticed that unless I
> save the excel file as Excel 4.0, I am not able to see any of the excel
> tables in the view. This also limits the number of rows to 16K. Is there any
> configuration that I can change and use excel 2002 files for import?


try to install mdac 2.8 and the latest BDE. It might be that either is not
capable of reading excel2k files.

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm




  #3  
Old 11th December 2003, 04:12 AM
Srinivasan Iyer
 
Posts: n/a
Default Re: OT - Excel import to NexusDB

Thanks Hannes,
I will try that.
Srini.
"Hannes Danzl[NDD]" <hannes@nexusdb.dbnexus.com> wrote in message
news:3fd75585@wic040d....
> > I am trying to use BDE2NX to import some excel data. I noticed that

unless I
> > save the excel file as Excel 4.0, I am not able to see any of the excel
> > tables in the view. This also limits the number of rows to 16K. Is there

any
> > configuration that I can change and use excel 2002 files for import?

>
> try to install mdac 2.8 and the latest BDE. It might be that either is not
> capable of reading excel2k files.
>
> --
>
> Hannes Danzl [NexusDB Developer]
> Newsgroup archive at http://www.tamaracka.com/search.htm
>
>
>
>



  #4  
Old 12th December 2003, 01:58 PM
BF Deleen
 
Posts: n/a
Default Re: OT - Excel import to NexusDB

I use scalabium.com for my excel and other imports.

Regards from Calgary

"Srinivasan Iyer" <iyer1@optonline.net> wrote in message
news:3fd733b9@wic040d....
> I am trying to use BDE2NX to import some excel data. I noticed that unless

I
> save the excel file as Excel 4.0, I am not able to see any of the excel
> tables in the view. This also limits the number of rows to 16K. Is there

any
> configuration that I can change and use excel 2002 files for import?
> Thanks in advance.
> Srini.
>
>





Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC, Excel and Memo-BLOB: Missing data Karsten Lehnart nexusdb.public.support.odbc 6 21st November 2005 04:35 AM
NexusDB 202 and ODBC driver and Excel Kick Martens nexusdb.public.support.odbc 2 27th September 2005 06:54 AM
Import routine via ODBC breaks James K Smith nexusdb.public.support.odbc 3 8th April 2004 07:29 AM
how to import old reportbuilder reports? Didier GAWTARNIK nexusdb.public.support.thirdparty 0 2nd February 2004 09:13 AM
OT: Export-Tool NEXUS-->Excel Andreas Brietz nexusdb.public.discussions 10 3rd October 2003 09:32 PM


All times are GMT +11. The time now is 11:04 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.