Importing text file
- From: "Reggie" <NoSpam_chief123101@xxxxxxxxxxxxxxxx>
- Date: Fri, 10 Jun 2005 02:09:46 -0700
Hi and TIA. Using VS.Net 2003 I built an ASP.Net Web application using
VB.Net. I connect to an SQL db(SQL Server 2000) and am setup to
write/read/edit data no problem. I'm having a problems with the following
scenario. Any help, advice, or if you could point me in the right direction
is highly appreciated.
1. The user clicks a button which opens the Find file dialogue box.
2. They navigate to the text(or possible dbf file) and click ok.
3. The a temp table is created and the text(dbf) file is imported
creating the temp table
4. A procedure is run the takes my active data(an existing table) and
archives(appends) that data to an archive table. Before this though the
data in the archive table needs to be deleted.
5. The data from my live table is deleted.
6. Data from my imported temp table is appended to the live table.
7. Temp table is deleted.
I read some stuff about DTS packages but I'm not real familiar with SQL
Server and don't know how exactly to call the DTS package from my
application and/or if DTS is actually the way to go. The text file is
delimited and contains field names that will map directly to my existing
tables. Not looking for a hand out so if you could get me pointed in the
right direction I'm not against doing more research, but at this time I'm
not exactly sure where to start. Thanks again for your time.
.
- Prev by Date: Data migration from DB Pocket PC to SQL Server
- Next by Date: Custom App Wizard
- Previous by thread: Data migration from DB Pocket PC to SQL Server
- Next by thread: Custom App Wizard
- Index(es):
Relevant Pages
|
