Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
DBIsam database JOINed to MS Access table |
Sun, Feb 24 2008 3:10 PM | Permanent Link |
Ian Turner | I have a horrible suspicion that this question is either blindingly obvious or stupidly
impossible, but here goes. I have been asked to design a database to store microbiological swab tests but this will need to link to an existing employee table in an MS Access database. I would like to use DBIsam, so does anyone know of a way to produce a SQL query based on tables in the proposed DBIsam database joined to the MS Access Employee table? I should say that I realise that I could use the Access table as a lookup table but really would prefer to create a query that linked in columns from the Access table. Many thanks, Ian |
Mon, Feb 25 2008 3:55 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< I have a horrible suspicion that this question is either blindingly obvious or stupidly impossible, but here goes. >> There are no stupid questions here, just an occasional stupid SQL answer from me that Robert Kaplan promptly corrects. << I have been asked to design a database to store microbiological swab tests but this will need to link to an existing employee table in an MS Access database. I would like to use DBIsam, so does anyone know of a way to produce a SQL query based on tables in the proposed DBIsam database joined to the MS Access Employee table? I should say that I realise that I could use the Access table as a lookup table but really would prefer to create a query that linked in columns from the Access table. >> You can't do the query in DBISAM and join the Access table, but you can do it the other way in Access via our ODBC Driver. The other option would be to quickly pull in the Access table via the ADO components into an in-memory DBISAM table and then use that in the query instead. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Feb 25 2008 7:08 PM | Permanent Link |
Ian Turner | Tim,
<<You can't do the query in DBISAM and join the Access table, but you can do it the other way in Access via our ODBC Driver. The other option would be to quickly pull in the Access table via the ADO components into an in-memory DBISAM table and then use that in the query instead.>> Thanks for clearing the fog on that one. I have just set up a routine today to dump the Access table into a DBIsam disk based table, but the in-memory table sounds like a good option to try out. Many thanks, Ian |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |