A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

SDF files.



 
 
Thread Tools Display Modes
  #1  
Old August 26th, 2009, 01:58 AM posted to microsoft.public.access.gettingstarted
Frank Martin
external usenet poster
 
Posts: 162
Default SDF files.

How do I import these into Access2003?

Regards, Frank


  #2  
Old August 26th, 2009, 02:10 AM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default SDF files.

What are SDF files?


"Frank Martin" wrote in message
...
How do I import these into Access2003?

Regards, Frank



  #3  
Old August 26th, 2009, 03:31 AM posted to microsoft.public.access.gettingstarted
Frank Martin
external usenet poster
 
Posts: 162
Default 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  
Old August 26th, 2009, 04:20 AM posted to microsoft.public.access.gettingstarted
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old August 26th, 2009, 05:23 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old August 26th, 2009, 08:16 AM posted to microsoft.public.access.gettingstarted
Frank Martin
external usenet poster
 
Posts: 162
Default 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  
Old August 26th, 2009, 11:40 AM posted to microsoft.public.access.gettingstarted
Philip Herlihy[_2_]
external usenet poster
 
Posts: 64
Default 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  
Old August 26th, 2009, 06:06 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old August 26th, 2009, 11:11 PM posted to microsoft.public.access.gettingstarted
Frank Martin
external usenet poster
 
Posts: 162
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.