Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Customer List 2

Status
Not open for further replies.
beatdown

beatdown

Technical User
Feb 27, 2005
85
US
We use MAS-200, and would like to export a list of all our customers names & addresses, to an excel spreadsheet, or comma delimited file. Can anyone tell me how to do this?

Thanks!
 
Sort by date Sort by votes
You can do this a number of ways. Probably the easiest is to open Excel, go to Data, External Data, Import Data. You will be prompted for the Data Source, select the SOTAMAS90 DSN, you will then have to log into MAS and will be presented with a list of tables. Then just select the Customer Master file, AR1 and it will pull it into Excel.
 
Upvote 0 Downvote
BigLouie,

Thanks so much, you are the man! This gave me exactly what I needed.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hbkegreer
  • Locked
  • Question
Credit memo applied to wrong customer. How do I remove?
Replies
0
Views
190
hbkegreer
hbkegreer
tripplanningmom
  • Locked
  • Question
Missed customer pre-payment/down payment
Replies
1
Views
63
LouieGrandie
LouieGrandie
Llazwas
  • Locked
  • Question
Script to auto populate SO lines with UDF from Customer Maintenance
Replies
1
Views
65
dfeller
dfeller
SHennes
  • Locked
  • Question
Need to Export the Vendor Info from A/P
Replies
2
Views
85
LouieGrandie
LouieGrandie
chewyboy
  • Locked
  • Question
Mas90 3.51 data export
Replies
2
Views
36
AndyMc
AndyMc

Part and Inventory Search

Sponsor

Back
Top