![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » Search Forums » Search Results » View Thread |
Messages 11 to 11 of 11 total |
![]() |
Mon, Feb 16 2009 3:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Dan, << A simple import in csv format is a good idea. >> Duh, I also forgot one simple thing. You could use stores to accomplish the creation/querying of such data: 1) Create the CSV file in the external module and write it to a local store on the server. 2) Using the remote session on the client, import the CSV file into a temporary table that you create for just this purpose (CREATE TEMPORARY TABLE). 3) Use the IMPORT TABLE statement to import the CSV file into the temporary table. 4) Now you can query this table, etc. just like any other table. 5) Drop the temporary table when you are done with it. The entire sequence of events above all takes place on the ElevateDB Server. You can find out more about stores here: http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=0&topic=20 -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Monday, July 1, 2024 at 03:00 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |