If you have had a new database set up, and need the same suppliers in this databases as you have in others. Rather than manually setting them up, you can use AOI to download suppliers from one database and then upload into another database.
To pull suppliers you wish to add to the new database:
Open Excel and click the Access tab.
Click Templates then click Setup Update Template.
Select the Database you wish to pull the suppliers from.
Click New Template then click Next.
Click Purchase Ledger and then click Supplier Accounts.
click Next then drag Supplier Code into the Column Field and set the range.
Add any other relevant fields into the Column Fields box.
Click Insert.
To add the suppliers to the new database:
Open a new Sheet in Excel and click the Access tab.
Click Templates then click Setup Update Template.
Select the new database you wish to add the suppliers to.
Click New Template then click Next.
Click Purchase Ledger then click Add Supplier Accounts
Click Next then drag Supplier Code into the Column Field and set the range.
Add any other relevant fields into the Column Fields box.
Click Insert.
Copy the information from the first Excel Sheet and paste it into the second Excel sheet.
Click Update.