Skip to main content

We have a database of about 400 prospects. One set of user-defined fields lists their total income and expenses for last year, as well as a rank number on some sort of business list out there. We had this data as part of when we initially imported this from Excel into Maximizer. We use "regular" (non-Enterprise) Max 9.

The new rank and income/expense numbers have just been published for these prospects, so we want to update these fields. But I don't see in Max an easy way to bring in say and Excel chart whose companies and field names match the same in our Max DB and Max just updates them instead of importing duplicate entries.

I find it somewhat hard to believe that software like this would have such a grave limitation where I'd have to go in and manually update 400 records. Is this really true? If so is there some third-party package I could buy that would do this for us? Please advise, thanks!
Original Post

Replies sorted oldest to newest

Maybe that's the problem, I think MS Access exports to a file with an .XML extension, not one with .MXI

A consultant we work with at times who's usually pretty nice about quick free answers said creating MXI files is something they'd have to program, which I found hard to believe. Is is as simple as changing the file extension after the fact?
It seems feasible (at least in theory) to use an MS_Word mail merge with an Excel or Access data file to create the "guts" of an MXI file. The template would include the XML tags with the merge fields between them. After the merge you could paste the standard XML header stuff at the top, save the document as text, and then import that. Not completely automatic, but worth a try IMO.
Last edited by gord

Add Reply

Post
LEGAL INFO
CONTACT US
Copyright 2007-2018 Advoco Solutions Ltd. All Rights Reserved.
×
×
×
×
Link copied to your clipboard.
×