Hi David,
How are you doing on this issue. Does the suggestions in my last reply help
a little? If there're anything else we can help, please feel free to post
here.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure!
www.microsoft.com/security
--------------------
| X-Tomcat-ID: 56268410
| References: <#Y************ **@TK2MSFTNGP14 .phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From:
st*****@online. microsoft.com (Steven Cheng[MSFT])
| Organization: Microsoft
| Date: Mon, 03 Oct 2005 03:51:26 GMT
| Subject: RE: File Import Wizard
| X-Tomcat-NG: microsoft.publi c.dotnet.genera l
| Message-ID: <lz************ *@TK2MSFTNGXA01 .phx.gbl>
| Newsgroups: microsoft.publi c.dotnet.genera l
| Lines: 88
| Path: TK2MSFTNGXA01.p hx.gbl
| Xref: TK2MSFTNGXA01.p hx.gbl microsoft.publi c.dotnet.genera l:51152
| NNTP-Posting-Host: tomcatimport2.p hx.gbl 10.201.218.182
|
| Hi David,
|
| Welcome to MSDN newsgroup.
| From your description, you're wanting to build a file import system which
| allow the client user to provide some files (some wellknown format) and
| then import the file content as records into the database server, also
the
| system is web based, yes?
|
| As for such application, I think we can separate it into two parts:
|
| 1. In the ASP.NET web page, we provide a wizard like UI to collect
| information from the clientuser, also use a <input file ..> element to
let
| the client user upload file. Then, when the user submit the page, the
data
| and file will be posted to the server for processing.
|
| 2. In the ASP.NET webapp's serverside, we just use our serverside code
| logic to parse the uploaded file stream and loop through the text datas
in
| it and build SQL data execution command to insert data into database.
This
| is the same as we programmaticall y import a file into database in winform
| or console application, you can make the parsing and accessing database's
| code into a separate component.
|
| Currently I haven't found any existing code samples, if you have any
| further and more detaild question, we can have some further discussion on
| them.
|
| Thanks,
|
| Steven Cheng
| Microsoft Online Support
|
| Get Secure!
www.microsoft.com/security
| (This posting is provided "AS IS", with no warranties, and confers no
| rights.)
|
|
|
|
|
|
|
|
| --------------------
| | From: "David Berry" <db****@mvps.or g>
| | Followup-To: microsoft.publi c.dotnet.langua ges.vb
| | Subject: File Import Wizard
| | Date: Sun, 2 Oct 2005 11:50:56 -0400
| | Lines: 83
| | MIME-Version: 1.0
| | Content-Type: multipart/alternative;
| | boundary="----=_NextPart_000_ 000A_01C5C747.8 CD60990"
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| | Message-ID: <#Y************ **@TK2MSFTNGP14 .phx.gbl>
| | Newsgroups:
| microsoft.publi c.dotnet.genera l,microsoft.pub lic.dotnet.lang uages.vb
| | NNTP-Posting-Host: adsl-64-252-4-30.adsl.snet.ne t 64.252.4.30
| | Path: TK2MSFTNGXA01.p hx.gbl!TK2MSFTN GP08.phx.gbl!TK 2MSFTNGP14.phx. gbl
| | Xref: TK2MSFTNGXA01.p hx.gbl microsoft.publi c.dotnet.langua ges.vb:108605
| microsoft.publi c.dotnet.genera l:51140
| | X-Tomcat-NG: microsoft.publi c.dotnet.genera l
| |
| | Hi All. I'm looking for any help or sample code that can show me how
to
| make a file import wizard in ASP.NET (VB preferred) like the one that MS
| Access uses. I'm working on a web site where the user has the ability to
| upload a file (.txt or .csv). The data in the file may be comma
| delaminated, tab delaminated, fixed width etc (we don't know).
| | What I'd like to create is something like MS Access uses to import an
| Excel file into the database. Access has a wizard that walks the user
| through steps such as - is the first row the header, ignore the first "x"
| number of rows, is it comma, tab, semi colon etc delaminated, allows you
to
| adjust what data goes in what field etc And then does the import into the
| database. I need to recreate something exactly like this but web-based.
| I'd also like the user to be able to store their preferences so that the
| next time they go to upload the same type of file the can just choose a
| pre-made preference that knows what to do. The file would then get
| imported into a database (Access or SQL Server).
| | Any suggestions on where to start or code samples to look at?
| | Thanks
| |
|
|
