Import an SDB file

[Guest]

How do I import an SDB file database into my access database. When I want to
import the file it does not show the file but I can open this files in
Access? Even if I try to use an append query?????

 

[Brendan Reynolds]

There are at least 10 known uses of the SDB extension, Charles. (See the
link below). Do you know what program was used to create your file?

http://filext.com/detaillist.php?extdetail=SDB

 

[John Nurick]

Hi Charles,

SDB is not a standard Access file extension. If it is an Access database
that has had its name changed, you can open it by making a copy of the file
and changing the extension to .MDB.

If that doesn't work, you will need to identify the application that created
the file (see e.g. www.fileext.com and www.fileinfo.net if you don't know).
If this is a database system you may be able to to obtain an ODBC driver for
its SDB files, and use the driver to connect Access to the data. Otherwise,
use the applicatoin that created the file and see if it can export the data
in a form Access can import.

 

[Guest]

This SDB Database is run in a seperate program. So how can I import the data
without opening the SDB database into Access? Or is there coding available
for me to copy that SDB Database and paste it as an MDB file?

 

[Brendan Reynolds]

Did you look at the URL I posted, Charles? It shows that an SDB file could
be any one of the following ...

ACT! Sales Data File
Group Mail Subscriber Plug-in File
SideKick 2 Database
Simply Accounting File
SmartQuest Survey Database Configuration
STRIP SDB Utility File
Summer Camp Scheduler Database
Windows Compatibility Solution Database
Windows 2000 Security Configuration and Analysis Database
yEncExpress Database

These are just the known uses by publicly released software.

Access doesn't have any built-in facility to import any of those, but if you
can identify which type of SDB file you have, then you could look for
information on the vendor's web site, or search for information at Google.
Without that information, though, I'm afraid you're in
'needle-in-a-haystack' territory.