If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SDF files.
How do I import these into Access2003?
Regards, Frank |
#2
|
|||
|
|||
SDF files.
What are SDF files?
"Frank Martin" wrote in message ... How do I import these into Access2003? Regards, Frank |
#3
|
|||
|
|||
SDF files.
"Steve" wrote in message m... What are SDF files? "Frank Martin" wrote in message ... How do I import these into Access2003? Regards, Frank These are chemical-data files, and are all news to me. Wiki says something about them, and I want to import them into Access: http://en.wikipedia.org/wiki/Chemica...Common_Formats http://en.wikipedia.org/wiki/Chemical_table_file#SDF Please help. |
#4
|
|||
|
|||
SDF files.
Frank,
Depending on which program is generating the file, can you export to a a different format... one that Access will recognize? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Frank Martin" wrote in message ... How do I import these into Access2003? Regards, Frank |
#5
|
|||
|
|||
SDF files.
On Wed, 26 Aug 2009 12:31:38 +1000, "Frank Martin" wrote:
These are chemical-data files, and are all news to me. Wiki says something about them, and I want to import them into Access: IT's been a few years since I worked with them, but they're from Molecular Design Ltd., now apparently acquired by someone else: http://www.symyx.com/. This company apparently still offers ISIS/Base and ISIS/Draw, the software that creates SDfiles. About the time we parted company they were finishing up a project to store the data in ORACLE relational tables; I am pretty sure that SDfiles are just an external file export format. See http://www.symyx.com/products/softwa...base/index.jsp or contact the company directly. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
SDF files.
Thank you. A commercial supplier of laboratory chemicals
offers product data for download in this format. http://www.acros.com/DesktopModules/...hString=iodide (see bottom of site page) Regards, Frank "John W. Vinson" wrote in message ... On Wed, 26 Aug 2009 12:31:38 +1000, "Frank Martin" wrote: These are chemical-data files, and are all news to me. Wiki says something about them, and I want to import them into Access: IT's been a few years since I worked with them, but they're from Molecular Design Ltd., now apparently acquired by someone else: http://www.symyx.com/. This company apparently still offers ISIS/Base and ISIS/Draw, the software that creates SDfiles. About the time we parted company they were finishing up a project to store the data in ORACLE relational tables; I am pretty sure that SDfiles are just an external file export format. See http://www.symyx.com/products/softwa...base/index.jsp or contact the company directly. -- John W. Vinson [MVP] |
#7
|
|||
|
|||
SDF files.
Frank Martin wrote:
Thank you. A commercial supplier of laboratory chemicals offers product data for download in this format. http://www.acros.com/DesktopModules/...hString=iodide (see bottom of site page) Regards, Frank "John W. Vinson" wrote in message ... On Wed, 26 Aug 2009 12:31:38 +1000, "Frank Martin" wrote: These are chemical-data files, and are all news to me. Wiki says something about them, and I want to import them into Access: IT's been a few years since I worked with them, but they're from Molecular Design Ltd., now apparently acquired by someone else: http://www.symyx.com/. This company apparently still offers ISIS/Base and ISIS/Draw, the software that creates SDfiles. About the time we parted company they were finishing up a project to store the data in ORACLE relational tables; I am pretty sure that SDfiles are just an external file export format. See http://www.symyx.com/products/softwa...base/index.jsp or contact the company directly. -- John W. Vinson [MVP] If you look at the bottom of the link you quote there is also an option to export as Excel (you get a tab-separated text file). That could be imported into Access much more readily than the SDF file, which (from the Wikipedia link) appears to be a multi-line format, which takes real work to convert into the sort of structure a relational database uses. I've done quite a bit of this sort of data conversion, but I wouldn't attempt to import the SDF format without having a definitive statement of the data structure (including any optional elements). Even with the tab-separated form, you'd need to be pretty sure what you are dealing with. You might try downloading the "Excel" version and examining it in Excel. If you're happy with the way it looks, and it seems consistent, then try importing the file into Access, having set up a table design first which matches the data type (number, string, etc) you want in each field (Access will otherwise "guess", based on what it finds in the first record). Trial-and-error is the usual approach! Try importing a few fields at a time, adding further ones progressively, and look out for the option in Access to save an "import specification" for reuse. HTH Phil, London |
#8
|
|||
|
|||
SDF files.
On Wed, 26 Aug 2009 11:40:24 +0100, Philip Herlihy me@localhost wrote:
If you look at the bottom of the link you quote there is also an option to export as Excel (you get a tab-separated text file). That could be imported into Access much more readily than the SDF file, which (from the Wikipedia link) appears to be a multi-line format, which takes real work to convert into the sort of structure a relational database uses. shudder I was REALLY REALLY glad when Molecular Design offered the Excel export option. I spent a bad couple of months back in 1992 or so trying to extract data from sdfiles. -- John W. Vinson [MVP] |
#9
|
|||
|
|||
SDF files.
"Philip Herlihy" me@localhost wrote in message ... Frank Martin wrote: Thank you. A commercial supplier of laboratory chemicals offers product data for download in this format. http://www.acros.com/DesktopModules/...hString=iodide (see bottom of site page) Regards, Frank "John W. Vinson" wrote in message ... On Wed, 26 Aug 2009 12:31:38 +1000, "Frank Martin" wrote: These are chemical-data files, and are all news to me. Wiki says something about them, and I want to import them into Access: IT's been a few years since I worked with them, but they're from Molecular Design Ltd., now apparently acquired by someone else: http://www.symyx.com/. This company apparently still offers ISIS/Base and ISIS/Draw, the software that creates SDfiles. About the time we parted company they were finishing up a project to store the data in ORACLE relational tables; I am pretty sure that SDfiles are just an external file export format. See http://www.symyx.com/products/softwa...base/index.jsp or contact the company directly. -- John W. Vinson [MVP] If you look at the bottom of the link you quote there is also an option to export as Excel (you get a tab-separated text file). That could be imported into Access much more readily than the SDF file, which (from the Wikipedia link) appears to be a multi-line format, which takes real work to convert into the sort of structure a relational database uses. I've done quite a bit of this sort of data conversion, but I wouldn't attempt to import the SDF format without having a definitive statement of the data structure (including any optional elements). Even with the tab-separated form, you'd need to be pretty sure what you are dealing with. You might try downloading the "Excel" version and examining it in Excel. If you're happy with the way it looks, and it seems consistent, then try importing the file into Access, having set up a table design first which matches the data type (number, string, etc) you want in each field (Access will otherwise "guess", based on what it finds in the first record). Trial-and-error is the usual approach! Try importing a few fields at a time, adding further ones progressively, and look out for the option in Access to save an "import specification" for reuse. HTH Phil, London Thanks. I hadn't thought of this. Though I have Excel on my computer I never use it because I use Access. Frank |
Thread Tools | |
Display Modes | |
|
|