import/export Nutshell to Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gough - 29 Dec 2003 15:46 GMT

Customer address data is stored in Nutshell data base file. How can I get it imported into an Access file?

Reply to this Message

Douglas J. Steele - 29 Dec 2003 18:13 GMT

Can Nutshell export to a file format that Access recognizes?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> Customer address data is stored in Nutshell data base file. How can I get it imported into an Access file?

Reply to this Message

gough - 29 Dec 2003 23:51 GMT

Under the "Add" option, "input from file" lists ASCII, dBASEII, DIF, and Leading Edge. No mention is made of exporting. If the program can read these coming in, can the data be configured to go out in some format acceptable to Access or other data base management programs?

Reply to this Message

Douglas J. Steele - 30 Dec 2003 01:30 GMT

Sorry: no idea (and I don't seem to be able to find anything useful on
Nutshell Databases through Google).

Unless Nutshell has some export capabilities, or there's an ODBC driver for
Nutshell, I think you may be out of luck.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> Under the "Add" option, "input from file" lists ASCII, dBASEII, DIF, and Leading Edge. No mention is made of exporting. If the program can read

these coming in, can the data be configured to go out in some format
acceptable to Access or other data base management programs?

Reply to this Message

John Nurick - 30 Dec 2003 07:38 GMT

Hi Doug and Gough,

It took some serious googling to find it (the phrase "nutshell database"
doesn't seem to appear anywhere on the maker's rather uninformative
website), but according to http://www.fairsoft.com/tech_specs.lasso,
current versions of Nutshell can
    "Link to/from any:
        - MS Office product
        - ODBC Compliant Database
        Oracle
        SQL Server
        Sybase
        Access"
while according to
http://www.infotoday.com/cilmag/feb01/tompson&goehring.htm Nutshell Plus
II (DOS) "did not provide any structured options for exporting" but
could export plain text that then had to be edited into standard
delimited format.

One approach would be to set up the Windows "Generic/Text only" printer
driver, and get Nutshell to print the data in the plainest possible
report format; then print that to file.

But first it's probably worth emailing Fairsoft tech support to see what
they say.

>Sorry: no idea (and I don't seem to be able to find anything useful on
>Nutshell Databases through Google).
>
>Unless Nutshell has some export capabilities, or there's an ODBC driver for
>Nutshell, I think you may be out of luck.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message