ADO.NET,C#, and MS:Access
-
Hi Gang, Here's what I've got, I've got information stored in one table/database that I'd like to move to another table/database. Sounds pretty simple doesn't it? Well, here's where the pickle comes into play. The tables could potentially be dynamic. So I can't used a predefined DataSet to do the moves, so I have to recreate the datasets each time. That part isn't even necessarily the problem. The problem I'm running into is: What happens when my tables have memo fields in them? Some of our tables have Ole embedded (Not my choice, but I have to live with it) in them that also need to be mapped. I'm trying to do this all with ado.net using C#. If I can't I'll probably just end up writing it in VB6. I know we can do it in there, we have. But then again, that's using DAO, not ADO.Net. Anybody have any suggestions? Thanks, Nick Env: Studio 2003, MS:Access 2000 Databases, WinXP Pro+Patched This are my own opinions. You know the rest.....