Comparing MSDE to Access - Import Wizard?

I need to rewrite an Access 2000 application to use MSDE and .NET. The one
feature I'm worried about is the ability to import tables and/or data from
Access, Excel, txt, even Outlook.
The Access Import Wizard is used a lot here and the app in question has a
lot of VBA code that works with imported tables for getting data into the
database. Does MSDE have an Import Wizard like Access? Will I have to code
all this functionality from scratch?
Thanks in advance.
hi,
deko wrote:
> I need to rewrite an Access 2000 application to use MSDE and .NET. The one
> feature I'm worried about is the ability to import tables
> and/or data from Access, Excel, txt, even Outlook.
> The Access Import Wizard is used a lot here and the app in question
> has a lot of VBA code that works with imported tables for getting
> data into the database. Does MSDE have an Import Wizard like Access?
> Will I have to code all this functionality from scratch?
> Thanks in advance.
MSDE comes with no tools but oSql.exe, BCP.exe and the DTS runtime... you
can perhaps modify your import schema to sue such tools... or, youn can even
rely on Access based database as linked server to use the JET OLE DB
provider to a access dbf, txt, excel, mdb .... and the like...
http://tinyurl.com/9vdrz
http://tinyurl.com/anvbn
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply