By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,484 Members | 1,811 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,484 IT Pros & Developers. It's quick & easy.

MSDE Upgrade question

P: n/a
Is there an Import Wizard for MSDE?

In Access, when you select File >> Get External Data >> Import, you get a
Wizard that lets you browse for a file to import by file type (txt, Excel,
etc.). If you select a text file, you get the Import Text Wizard; if you
select an Excel file, you get the Import Spreadsheet Wizard; if you select
Outlook, it automatically finds your Outlook Address Book - and so on for
other file types.

I looked at the Bulk Copy Utility which may be some help, but what I need is
an Import Wizard for MSDE that is at least as good as the Import Wizard for
Access (the app in question is being rewritten from Access 2000 to .NET and
MSDE).

The goal is to let users easily import data from a variety of file formats -
xls, txt, html, xml - as well as from Access and Outlook. The Access Import
Wizard does a great job of this by representing the contents of the selected
file in table format and allowing users to manipulate the schema prior to
importing the data into a new table.

Are there any third-party utilities or other solutions?

Thanks in advance.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
deko wrote:
Is there an Import Wizard for MSDE?


Use the Enterprise Manager, right-click on a DB, import ... then the wizard
opens. Supports plenty of formats.

If you don't have it:
http://www.amazon.com/exec/obidos/AS...496888-1586445

Peter

--
No mails please.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.