Microsoft Access with Dreamweaver

[richkoi]

RESOURCES:
I have a table set up in Microsoft Access (easily converted to XL or comma delimited) with each row representing a product. This table is a special products list so I only need to generate a website with these products once (in other words I do not need to update later, no dynamic page necessary). I use Dreamweaver MX to create my sites.

PROBLEM:
Pretty much what I want to do is a "mail merge" from Access to Dreamweaver. I used to do mail merges in MS Word, using Access, to generate similar specials products flyers for customers...

I guess I could always use MS Word again and save as an HTML file...but if you've ever tried that Microsoft sticks a bunch of unnecessary code into the html.

How do I do this?

Any help is greatly appreciated.

Thanks,

Rich

[HardCoded]

I'm not sure how this will work for you, but this is how I'd do it.

I'd export to CSV, and then use an editor like Textpad with decent regex capabilities to format each line the way you like. I don't use DW, so I don't know if its regex has the power you need to do this. But the last time I tried to use it, a couple of years ago, it sure didn't.

[swstyles]

I am pretty sure you can import an excel table into dreamweaver. I will try it and get back to you.

[swstyles]

Ok,

I just went into excel created a simple document, saved it as a tab delimited txt file and imported it into Dreamweaver.

Save your excel file as a tab del txt file
In Dreamweaver from the menus insert>table objects>insert tabular data
Choose the txt file and provide the parameters

that's it

[richkoi]

Thanks, I need to do a little more than just import a table. What I am doing now is actually creating a mail merge in Microsoft Word and then copying and pasting that directly into Dreamweaver. Seems to work fine.

Thanks,

Rich