Partner Zone

Importing Customer cards

Peter_BKPlus
Partner
39 Posts
Partner
Australia

39Posts

2Kudos

0Solutions

Solved: Go to Solution

Importing Customer cards

I wish to import customer cards from Access data base. What type of file do I need to use

1 REPLY 1
shortred
Trusted Cover User
45 Posts
Trusted Cover User
Trusted Cover User

45Posts

12Kudos

2Solutions

Accepted Solution Solved

Re: Importing Customer cards

Peter, 

 

Best practice is to export the report you want - Cards in this case - using all the fields you will need to add in your new data.  Cards prefers to export as a .txt file, which you can then open in Excel to better view the fields. Use this as a template to fill in your new records - you can probably export in a close enough format from Access once you see what the format needs to be. Saving the completed file as a csv should allow you to import it back into MYOB with your new data. Remember to leave the headers in place! It makes allocating fields much easier.

 

Note that you MUST choose at least one of Card ID, Co./Last Name or Record ID as one of the fields you export and import. 

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post