Switching from Panorama to Access

[Guest]

Greetings-
I run a small mail order business from my home. We have always used
Panorama Direct on a Mac to generate labels, maintain inventory, create
invoices, send bills, etc. I would like to export my data out of Panorama on
my Mac and onto Access onto my PC.
Any experience out there on how to do this and whether Access is the correct
program I should be using for such a purpose?
Thanks-

 

[Joseph Meehan]

Greetings-
I run a small mail order business from my home. We have always used
Panorama Direct on a Mac to generate labels, maintain inventory,
create invoices, send bills, etc. I would like to export my data out
of Panorama on my Mac and onto Access onto my PC.
Any experience out there on how to do this and whether Access is the
correct program I should be using for such a purpose?
Thanks-

Likely you will be able to export the data, but not any forms, reports
etc.

What format is the data in with Panorama? dBase? Can it export to
dBase, text or other??

 

[Guest]

Thanks for responding Joseph. Not having the Mac near me at the moment, I am
not sure whether the data is technically what you would refer to as "dbase."
Our field consist of names, addresses, products, prices, quantities, etc. If
I am able to set up the appropriate fields that correspond to Panorama in
Access, I would be satisfied to simply export the data from one to the other.
Does your experience with Access tell you that it would suffice for my
purposes?
Thanks
Andy

 

[Joseph Meehan]

Thanks for responding Joseph. Not having the Mac near me at the
moment, I am not sure whether the data is technically what you would
refer to as "dbase." Our field consist of names, addresses, products,
prices, quantities, etc. If I am able to set up the appropriate
fields that correspond to Panorama in Access, I would be satisfied to
simply export the data from one to the other. Does your experience
with Access tell you that it would suffice for my purposes?
Thanks
Andy

The fields are not really a problem. With Access you can have many
fields each with the name and data type of your choice. The format of the
file in which the data is stored is what is important. I am sorry I don't
know the Panorama field type. If you can find someone who knows it well,
they may know the file format or may know if you can export the data in a
standard format. You may want to load up Panorama and see if it offers an
option to export data. If it offers a dBase format use that. Access can
read it very easily and know what types of data etc you have.

 

[Guest]

Thanks Joseph for your suggestion. I will check into the exporting features
of Panorama to see if I can export in dbase format.
Happy Holidays!