Export Accpac Plus Field Names

[10downsview]

I am trying to help a charity export the data from each Accpac Plus module to Access 2000.

We can receive all the data from Accpac but cannot receive the field names.

Can we have a suggestion on how to export the data from for an example Receivables with the field names.

Your suggestion is appreciated.

 

[jayconverse]

Use Quik Reports. You still can't export the field names, but at least you can see the names on the screen.

Jay Converse
IT Director
Systemlink, Inc.

 

[10downsview]

Thank you for your suggestion, but we need the export with the field names.

 

[jayconverse]

Then set up a linked table in Access to the CSV file, with the Access Field Specifications giving the field names.

Jay Converse
IT Director
Systemlink, Inc.

 

[ettienne]

The fields are exported from Plus in the same order they appear on the export screen, so it is easy to match the field names to the export file.

 

[10downsview]

Re: Then set up a linked table in Access to the CSV file, with the Access Field Specifications giving the field names.

Please advise what a CSV file is as there is no such file in any Plus directory.

===
The fields are exported from Plus in the same order they appear on the export screen, so it is easy to match the field names to the export file.

We used to do this, but with all the different moduals and MANY accounts, this is too time consuming.

If we can not find a way of doing what we want, I guess we will have to purchase a product from Softtrack which does what we want.

 

[jayconverse]

CSV, fixed record length, whatever...

As long as it's a text file, MSAccess can link to it. Talk to your Access programmer, he'll know what to do.

Jay Converse
IT Director
Systemlink, Inc.

 

[ettienne]

Buy the ODBC link to Accpac Plus, then you can link the tables in Access and get the field names.

 

[jayconverse]

Ettienne -

Can you still get that product? I would have suggested it the first time, but I figured it was out of production.

Jay Converse
IT Director
Systemlink, Inc.

 

[ettienne]

Jay,

I'm not sure, but you can still download the demo.

 

[10downsview]

I will be purchasing the software from this company if anyone is interested.

http://www.softrak.com

 

[10downsview]

Please advise me of a link to obtain a demo version of the ODBC link to Accpac Plus and and other link available so that our client can decide on the best product for their need.

This link does not work

http://www.softlinesystems.com

Thanks

 

[jayconverse]

Have you heard about this cool new website? It's called "Google". You enter search words ("accpac odbc link plus"), and it finds things for you. Like this:

http://www.sageaccpac.com/products/options/aplusodbcLink/

Jay Converse
IT Director
Systemlink, Inc.

 

[10downsview]

Yes, you are correct in finding this page (again), BUT I cannot find a demo software copy to try or the cost of the product.

 

[jayconverse]

Well, Ettienne might know where to find it, but I don't. Face it, Accpac Plus is an officially dead product in 3 days. My opinion is that you're wasting your time and your client's time.

Jay Converse
IT Director
Systemlink, Inc.

 

[ettienne]

It was under the Sage Accpac Options downloads section under Plus products until recently, but it seems to have been removed. You will have to contact Accpac directly and hear if they will still sell it.

 

[10downsview]

Thank you for your assistance, but the charity I am trying to help has no money to upgrade the working software they are using and this is why I am looking for an ODBC connection.

 

[jayconverse]

Why are you being so obstinate? Call Sage and see what they'll do for you. Otherwise, do what we originally told you over a month ago.

Jay Converse
IT Director
Systemlink, Inc.

 

[grnelson]

If your data is Pervasive Btrieve based and you need to export it you can take a look at BtSearch at

http://www.nssdd.com.

It will expor to CSV format and will export the data plus the field names. ODBC is not required just the Windows Btrieve drivers.

Gil

 

[jayconverse]

Gil -

That won't work here, Accpac Plus data is in a proprietary ISAM format.

Jay Converse
IT Director
Systemlink, Inc.