pcsoft.us.windevCopyright 2026, PC SOFT10 Jan 2018 04:36:00 Z8 Jan 2018 19:07:00 ZI need to load data from a spreadsheet into a data table. I created a table in the Analysis that points to the spreadsheet and I created a query to preprocess (clean up) the data and I use this query to update the SQL data table (also declared in the analysis). I do it all in Windev. My problem is that on some files (the spreadsheet format is the same juts new data) fail with no logical reason while others work fine. If I take a smaller version of the file usually works. I can't find the solution. Is anyone out there using a similar approach with Excel and can point me in the right direction? THNX !! Joe Maldo30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63929/read.awp10 Jan 2018 04:36:00 ZHello Joe Re the file you having a problem with, it may be useful to have a look at the "xls" functions. They will allow you…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63929/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63929/read.awpExcel as a Back-End to a data tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63928/read.awp10 Jan 2018 03:18:00 ZSteven, I really appreciate your feedback. I will try this approach right away. The interesting thing about this is that I lo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63928/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63928/read.awpExcel as a Back-End to a data tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63914/read.awp9 Jan 2018 10:59:00 ZHi Joe, In the past, I tried your approach with Pervasive SQL (Btrieve) tables and WINDEV. I imported the tables in the Analys…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63914/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63914/read.awpExcel as a Back-End to a data tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63907/read.awp8 Jan 2018 23:54:00 ZThis is a query that displays on a table. When I run the query on a large file, 207MB it crashes. I will appreciate any help/d…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63907/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63907/read.awpExcel as a Back-End to a data tableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63906/read.awp8 Jan 2018 19:33:00 ZHi Joe FAILS.... How? On what line of code? What is the file like (name, size, number of lines)? ...https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63906/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63905-excel-back-end-data-table-63906/read.awpExcel as a Back-End to a data table