anyone can help? delphi 7 TADOTable cannot connect to 400 columns excel

I use a TADOConnection (e.g. connection1) to connect a Excel 2007 file with
about 400 columns in a worksheet, using the following connectionString:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\temp\exportFG.xlsx;Extended
Properties="Excel 12.0;HDR=YES;"
when I set the connected properties to true, no error occur.
but when i put a TADOTable and set its connection to connection1,
tableDirect = true, only 256 columns can be retrieved!! is this a limitation
in Delphi 7 components (I know before Excel 2007, a worksheet has maximum
256 columns only)
I am using Delphi 7.

Posted On: Sunday 7th of October 2012 09:46:40 PM Total Views:  412
View Complete with Replies

Related Messages:

How can I share code or create a static library in Delphi ?   (200 Views)
I have two related projects in my project group (Delphi 10, BDS 2006) that share a number of files, in a tree like this: ProjectGroup - Common - Utils.pas - ZLib.pas - Components.pas - GraphicApp.exe - MainApp.pas - GUI.pas - ConsoleApp.exe - MainConsole.pas - CLI.pas Now GraphicApp and ConsoleApp projects both use files in project Common. I would like Common to be some sort of a library project, library that GraphicApp and ConsoleApp would depend on. Does Delphi have native libraries Or can I set it somehow to output even a C++ like .lib file, and then use it in my other projects But I would still like to have types and forms in my library, and I am afraid this is hard to do with a .lib file I tried to create project Common as a package project, but then it would create a run-time file Common.bpl which works kind of like a ..dll, only in a Borlad - specific format. Meaning it has to stay near the executable, which my clients might not like, or be included in the system's PATH variable. I do not want any dll or dynamic libraries, I only have a number of source files that I want to use in both projects and what I need is a static library or some object files of some kind. Can I create a package like a static library, that would be linked in at compile time Does Delphi have a native static library format Or can I have some kind of project that just compiles the .pas files to .dcu files and then puts them somewhere, where I can use them in the other projects Every kind of project I saw wants to output some sort of executable, different than the .dcu files. Kind regards, Timothy Madden
D7--can run project, D7 locks up   (345 Views)
I can only run my application a few times inside of D7 then Delphi and the app lock up after loading the application and I have to end-task Delphi, which makes development really slow. The app shows up in the Task Managers 'Processes' list. The compiled line indicators show up on the left side of the tray. I put a break point on the DPR's 'begin' and it doesn't get there. Any hints on what I might look for D7, Windows XP.
How can i load TImage picture from a TMemoryStream that contain TJpeg data?   (239 Views)
"Ahmadi" wrote in message > How can i load TImage picture from a TMemoryStream that contain TJpeg > data You have to load the TMemoryStream into a TJPEGImage, and then you can Assign() that to the TImage.Picture property. > jp:=TJPEGImage.Create; Since you already have the TJPEGImage, you can get rid of the TMemoryStream completely, ie: var jp: TJPEGImage; begin ... jp := TJPEGImage.Create; try ... Image1.Picture.Assign(jp); finally; end; ... end; Gambit
bzip2.dll for download (or can someone compile it?)   (497 Views)
Hi all, I'm out hunting for bzip2.dll for use with Delphi classes (DI or Jcl Decompressors), but can't find a recent version ready compiled for Win32 Although google gives many hits on "bzip2.dll" but I don't trust clicking any of those cheap .dll mouse traps which is now littering the entire Internet. Latest source (1.0.5 as of mars 2008) is available from here, Perhaps can anyone compile it for me (or give a hint about a secure link for download). Anyone
Does anyone know how to do a keyword help lookup in a .chm file?   (152 Views)
I'm passing a keyword (that the user highlights in an edit control) to HtmlHelpViewer. But it crashes. In response to a call to Application.HelpKeyword(), THtmlHelpViewer.ShowHelp() GPFs at the call to Windows.HtmlHelpA(), which is in the OCX. This fails because it is trying to read from address $0001. HtmlHelpA() works perfectly when called in response to Application.HelpContext(). So it looks to me like there is a problem with the THH_AKLink structure that is being passed on a HelpKeyword call. But that is mostly hard-coded. There is a comment in the code that says WARNING: the documentation says HH_DISPLAY_TOPIC is required before this will work. Is that true It might be relevant but I don't know what the comment means. Any suggestions on what I can do to fix this -- Paul Keating The Hague
Delphi 2007 Pro can't start   (301 Views)
Hi. I have just bought Delphi 2007 Pro (The download version). It's downloaded and installed on my PC. Then I have registered the software. But when I try to open Delphi 2007 the IDE won't open. The ordinary Windows Error dialog box appears and the program has to be closed. Here is the following 2 errors I get. --- Exception EPackageRegistrationException in module coreide100.bpl at 000DA05D. Registration procedure, Dotnetreg.IDERegister in package c:\programmer\codegear\rad studio\5.0\bin\dotnetcoreide100.bpl raised exception class EOleSysError. OLE error 80131522, ClassID:{88487704-983C-4811-A96A-3DA723DD97AF} Do you want to attempt to load this IDE package the next time Codegear Delphi for Microsoft Windows run --- and --- Can't load package c:\programmer\codegear\rad studio\5.0\bin\TGIDE100.bpl (Borland Together IDE Integration). Exception EOleSysError in module rtl100.bpl at 00044A95 OLE error 80131522, ClassID: {46A75983-3834-436D-8A06-F5BEF75EF066} Do you want to attempt to load this IDE package the next time Codegear Delphi for Microsoft Windows run --- I have googlet after a solution and read in newsgroups but I haven't found a solution that solve the problem. -- I have installed Delphi 2007 six times now. One time on my laptop with Win XP Pro SP 2. No problems on this computer. 5 times on my stationary PC with Windows XP Pro SP 2. The last four times I have installed Delphi 2007 was on a clean and formated PC, where onlyWindows and the basic drivers were installed. But alle the 5 times I get the mentioned errors. I have googlet after a solution and read a couple of newsgroups but I haven't found a solution yet that solves the problem. Best regards Michael Srensen Denmark (Please bare over my bad english)
No blue dots in gutter, can't set a breakpoint   (138 Views)
Well, I can set a breakpoint but it announces itself as invalid the moment the program starts to run. What am I doing wrong Googling suggests three causes. I've tried them all and they don't apply. 1. CR/LF problems. These files have never been edited outside Delphi itself. 2. Non-ascii character in folder name. There is one, but copying to a different folder did not fix it. That's a dotnet problem anyway. 3. Project is pointing at source different from what I'm looking at. This does not appear to be it. If I introduce a syntax error the compiler stops at it. Also a dotnet problem anyway. -- Paul Keating The Hague
D2007 Just installed and cannot dubug old projects   (259 Views)
I have just installed RAD Studio 2007 and I am having trouble debugging old Delphi Win 32 projects (that debug fine in BDS 2006). When I press F8 i get the machine code debugger instead of my source code. Also, any breakpoints I set are invalid. New applications debug fine. I suspect it has something to do with 3 party components, but I have a lot of them installed and I don't know which one is causing this problem (if any). How can I find out what is causing this issue, and how do I fix it Using Rad Studio 2007 Pro. I assume that all the updates are installed. I executed the "Check for Updates" option that was put on the start menu and it says "No updates are avaliable"
How can I do to remove the Delphi compiler message "Return value of function 'MyFunction' might be undefined" ?   (274 Views)
Before to modify my "old" delphi code, I would like to know if there is a different way to remove the Delphi compiler message "Return value of function 'MyFunction' might be undefined". For example, here is some code that generates this warning message : .... type TrvSampleType = (stTwo, stThree); ..... function GetSampleType(AValue: Integer):TrvSampleType; begin if (AValue Mod 2 = 0) then Result := stTwo else if (AValue Mod 3 = 0) then Result := stThree; end; What I should write is something like that : type TrvSampleType = (stNone, stTwo, stThree); ..... function GetSampleType(AValue: Integer):TrvSampleType; begin if (AValue Mod 2 = 0) then Result := stTwo else if (AValue Mod 3 = 0) then Result := stThree else Result := stNone; end; But in fact, I don't want to add a new sample type value like a stNone, so how can I assign a "null" value to the Result var to avoid the warning Delphi message Thank you for your help. Laurent
Triton 1880 KW barcode scanner   (119 Views)
Has anyone written a barcode scanning application using Triton 1880 KW barcode scanner There is a demo app called CBScanner.exe and it works fine, but I can't see a way or find any info about integrating it with the app. The set uses Windows Mobile 2003.
D2007 cannot resolve Forms   (187 Views)
I'm a bit puzzled about D2007. I have a project which *is* compiling and executes. But the IDE keeps on complaining about an 'unresolved unit Forms' and proceeds to treat any items exported from the Forms unit as errors. D2007 compiles ok. The project runs without any errors. I don't understand. It just suddenly happened today. It didn't have this error the last time I ran D2007. Now when I just closed D2007 and re-opened it and opened the project, the errors are gone. I'm confused about this IDE. Any clarifications appreciated. Edmund
How i can remove the CPU windows in debug mode ?   (188 Views)
Hi Delphi 2007, upd3. When i debug anytime i go n CPU windows. how i can remove for always this windows I want work only in pascal source.
WinXP SP3 anyone?   (149 Views)
Did somebody installed Windows XP SP3 How does our favorite IDE run against it This link will start downloading it. Can be downloaded from windowsupdate too. Clment
cannot debug on Delphi 6 enterprise   (296 Views)
Hi all, I've copy/pasted a complete directory of y project to make some change in the new code without touching the original. When I try to compile, I don't see the bullets for debugging, so I can't put any break point or anything else. The code runs but I can't debug it...If I change the code I can see the changes in my program, but still can't debug it, my pas seems not to be found by Delphi but it's correctly compiled. What's appening I use Delphi 6 Enterprise.
Has anyone else had trouble   (122 Views)
Getting to the embarcadero web site
How can I ignore a mouse click?   (183 Views)
My application executes a third party dll that can take up to 15 seconds to execute and I want to ignore any mouse clicks on a particular control whilst the dll is running. If I set control.enabled to false, then call the dlll, then set enabled back to true after the dll has run any mouse clicks whilst the dll was running execute as soon as I re-eable the control. How can I lose them I have found that if I add a showmessage immediately before setting enabled to true the they do get lost but I do not want the user to see anything. (I have set the cursor to crHourGlass whilst the dll runs)
Error E2161 RLINK32 cannot open DFM file   (193 Views)
OK, this problem is starting to drive me crazy. It never happened to me with Delphi 7, but it is happening all the time with Delphi 2007. The problem is that when I first load my project into Delphi 2007 and then press F9 to compile it, any form that has a tab open in the IDE which contains a Frame object will cause an error: [DCC Error] E2161 Error: RLINK32: Error opening file "CharF.DFM" If I just press F9 again, it will work, but will then give the same error on the *next* form that is open in the editor. Once I have pressed F9 enough times, it will then compile and run the project. Once this happens, it never happens again, until I do a File/Close and reopen the project (or restart Delphi). If I remember to click on each form tab in the IDE and select the Design view to force each form to be displayed, then I do not get any errors. I've seen some old reports in Google about something like this that is apparently hard to reproduce. Unfortunately, my project is huge, so there is no way for me to post it to Quality Central. It's almost like some part of the IDE has the DFM file locked until it is first accessed. This is on Vista Business edition. The files themselves exist and the permissions are all properly set, so I don't think that is the problem. These files are *not* on a network drive...they are on a local drive. When I open the project in Delphi, it doesn't matter how long I wait before hitting F9. I can wait an hour and press F9 and still get the RLINK error the first time. So it's not something in the background that just has the file locked for a short time or anything like that. I have looked in the Vista Monitor tool which lists all of the files currently open by applications on the system, and nobody has these DFM files open. I am also using Castalia, Model Maker Explorer, and GExperts. But I have disabled each of these and that hasn't made any difference either. So I'm stumped. Yes, I can get around the problem by just hitting F9 again, or by remembering to manually open each form in Design mode, but it's getting to be a real annoyance. And the same project in Delphi 7 doesn't have this problem. Any advice is welcome.
Re: Time for a new keyboard - Suggestions anyone??   (121 Views)
"Kevin Powick" > Well, it's about time to replace my well-used, quite dirty, but now > failing keyboard. It's a very old Belkin Ergonomic Smartkeyboard and > has served me well over the years. > I've tried to research the topic of ergonomic keyboards via Google, but > most reviews are targeted towards gaming keyboards. I need one for > regular programming/typing. Old good Microsoft Natural Keyboard Pro rulez!!! It is durable, it is heavy, it is ergonomic, it have classic layout of numpad and arrow block, it have very clear touch and click. It is the best keyboard I ever seen and touched. My friend searched this keyboard entire Moscow for two days and found it. Only USD $85 and I'm happy owner of this useful thing. Perhaps Microsoft Ergonomic Keyboard 4000 also worth to look at.
Owner drawing, only draw cells that can be seen   (134 Views)
I have a TValueListEditor for which I'm using owner drawing to draw something in each cell. The problem is that when a user resizes the window and my TValueListEditor get smaller scroll bars appear and the user can then scroll. What happens is the owner drawing continues to happen for cells that are off the viewable area, if you scroll down then owner drawing still happens for cells which are off of the viewable space. This causes problems when my program attempts to draw something on the canvas in a location that is off of the screen. How can I limit owner drawing to only draw what the user can actually see, or determine which part of the list editor the user is viewing so that I can only draw on those. - Dan
AV I can't find.   (224 Views)
After leaving ReadDATFile but before returning to mnuUpDateCxClick execution goes off into FastMM4, and bombs with the message 'Access violation at addr 005F84AB in MyApp.exe. Read of addr 00000000.' Madexcept doesn't fire. The AV occurs running in and out of the IDE. Pausing and doing a Find Error on 005F84AB points at the line indicated.