import/export Nutshell to Access

[gough]

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

 

[Douglas J. Steele]

Can Nutshell export to a file format that Access recognizes?

--
Doug Steele, Microsoft Access MVP

(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?

 

[gough]

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?

 

[Douglas J. Steele]

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.

--
Doug Steele, Microsoft Access MVP

(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?

 

[John Nurick]

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.