1) Database schema, 2) Import utility

You can use the QSCImport utility to import items & suppliers. It will automatically connect the two tables. Make *absolutely* certain that the Supplier data for every record in the Items table has an EXACT match on the Supplier table. I'd recommend importing the Supplier table first.

I have (and have used with some success) EMS SQL Data Import/Export. It's a decent product, but for some tasks less is more - in this case, the QSCImport utility will probably treat you better.

If you don't have access to CustomerSource, you can download it from jeanholland.com (free registration required).

HTH, Tom

"P> I have two questions about Microsoft's RMS app.:

Thanks Tom. I will check out that utility.

Now I need to look at the database schema. Maybe it's not possible with just the Retail Mangement System application?

P> You can use the QSCImport utility to import items & suppliers. It will

Poppy,

Here's a schema for SO and HQ;

Jeff,

Thanks for the link. The page is clearly labelled "Partner Only Article" but the link works fine for Customers and has heaps of cool documentation to download. Finally, an explanation for QSBridge, my missing link and Hooks explained. Nice. Wish I'd found this two weeks ago. I searched high and low for this on Customer Source with no luck.

Poppy,

There are no restrictions on the database schema. Just install the SQL Server Client Interface and you have full access to everything. I think there are trial versions available. This works for MSDE and SQL.

Another way you can gain access to the schema and table definitions is to create an ODBC connection from the Administrator Control Panel in XP and link to it with MS Access. You can use MS Access to import data from Excel. Its also great for quick and easy queries and reports.

I personally did exactly what you're attempting using the Data Transformation Services (DTS) built into SQL Server. My sources were Excel spreadsheets with item information and supplier information. This took a lot of trial and error on a development system and isn't a particulary easy solution but it's as robust as you get.

These are grass roots suggestions. The utilities others have suggested are far easier solutions but if you want total control, use DTS.

SQL Server 2000 Evaluation Edition Download (120-Day Trial). This is full blown SQL Server 2000 but you only need to install the client tools and link the Enterprise Manager to the MSDE installation of RMS.