Hello,
I need to import data from a excel file into a SQL
Server. I would like to provide an asp.net interface for
that purpose. What would be the best to do that? A simple
textarea where the user can insert his data and press the
import button? The excel will be a csv file and some
values can be also empty or null. Pleas advise me.
Thanks
8  1506 
Where is the file? On the client?
"Vishal" <an*******@disc ussions.microso ft.com> wrote in message
news:9d******** *************** *****@phx.gbl.. . Hello,
I need to import data from a excel file into a SQL
Server. I would like to provide an asp.net interface for
that purpose. What would be the best to do that? A simple
textarea where the user can insert his data and press the
import button? The excel will be a csv file and some
values can be also empty or null. Pleas advise me.
Thanks
yes -----Original Message-----
Where is the file? On the client?
"Vishal" <an*******@disc ussions.microso ft.com> wrote in
messagenews:9d******* *************** ******@phx.gbl. .. Hello,
I need to import data from a excel file into a SQL
Server. I would like to provide an asp.net interface for
that purpose. What would be the best to do that? A
simple textarea where the user can insert his data and press
the import button? The excel will be a csv file and some
values can be also empty or null. Pleas advise me.
Thanks
.
Well, you can either upload the file to the server, or have the user enter
the values into your textarea. Your choice.
If uploading, Software Artisans has file upload components
Jeff
"Vishal" <an*******@disc ussions.microso ft.com> wrote in message
news:9d******** *************** *****@phx.gbl.. . yes
-----Original Message-----
Where is the file? On the client?
"Vishal" <an*******@disc ussions.microso ft.com> wrote in
messagenews:9d******* *************** ******@phx.gbl. .. Hello,
I need to import data from a excel file into a SQL
Server. I would like to provide an asp.net interface for
that purpose. What would be the best to do that? A simple textarea where the user can insert his data and press the import button? The excel will be a csv file and some
values can be also empty or null. Pleas advise me.
Thanks
.
I think i will go with the 2nd option. Once the user has
entered the values like this:
1,2,3
4,5,6,
7,8,9
How do I then read it line by line so that I can insert
each line to my dbase table?
Thanks -----Original Message-----
Well, you can either upload the file to the server, or
have the user enterthe values into your textarea. Your choice.
If uploading, Software Artisans has file upload components
Jeff
"Vishal" <an*******@disc ussions.microso ft.com> wrote in
messagenews:9d******* *************** ******@phx.gbl. .. yes
>-----Original Message-----
>Where is the file? On the client?
>
>"Vishal" <an*******@disc ussions.microso ft.com> wrote in
message >news:9d******* *************** ******@phx.gbl. ..
>> Hello,
>>
>> I need to import data from a excel file into a
SQL >> Server. I would like to provide an asp.net interface
for >> that purpose. What would be the best to do that? A
simple >> textarea where the user can insert his data and press
the >> import button? The excel will be a csv file and some
>> values can be also empty or null. Pleas advise me.
>>
>> Thanks
>
>
>.
>
.
Use the Excel ODBC driver to treat the file as another database.
Jeff
"Vishal" <an*******@disc ussions.microso ft.com> wrote in message
news:a8******** *************** *****@phx.gbl.. . I think i will go with the 2nd option. Once the user has
entered the values like this:
1,2,3
4,5,6,
7,8,9
How do I then read it line by line so that I can insert
each line to my dbase table?
Thanks
-----Original Message-----
Well, you can either upload the file to the server, or
have the user enterthe values into your textarea. Your choice.
If uploading, Software Artisans has file upload components
Jeff
"Vishal" <an*******@disc ussions.microso ft.com> wrote in
messagenews:9d******* *************** ******@phx.gbl. .. yes
>-----Original Message-----
>Where is the file? On the client?
>
>"Vishal" <an*******@disc ussions.microso ft.com> wrote in
message
>news:9d******* *************** ******@phx.gbl. ..
>> Hello,
>>
>> I need to import data from a excel file into a SQL >> Server. I would like to provide an asp.net interface for >> that purpose. What would be the best to do that? A
simple
>> textarea where the user can insert his data and press
the
>> import button? The excel will be a csv file and some
>> values can be also empty or null. Pleas advise me.
>>
>> Thanks
>
>
>.
>
.
As said I will go with the second option and therefore I
cant use the Excel Odbc driver. -----Original Message-----
Use the Excel ODBC driver to treat the file as another
database.
Jeff
"Vishal" <an*******@disc ussions.microso ft.com> wrote in
messagenews:a8******* *************** ******@phx.gbl. .. I think i will go with the 2nd option. Once the user has
entered the values like this:
1,2,3
4,5,6,
7,8,9
How do I then read it line by line so that I can insert
each line to my dbase table?
Thanks
>-----Original Message-----
>Well, you can either upload the file to the server, or
have the user enter >the values into your textarea. Your choice.
>
>If uploading, Software Artisans has file upload
components >
>Jeff
>
>"Vishal" <an*******@disc ussions.microso ft.com> wrote in
message >news:9d******* *************** ******@phx.gbl. ..
>> yes
>>
>> >-----Original Message-----
>> >Where is the file? On the client?
>> >
>> >"Vishal" <an*******@disc ussions.microso ft.com>
wrote in >> message
>> >news:9d******* *************** ******@phx.gbl. ..
>> >> Hello,
>> >>
>> >> I need to import data from a excel file into a
SQL >> >> Server. I would like to provide an asp.net
interface for >> >> that purpose. What would be the best to do that? A
>> simple
>> >> textarea where the user can insert his data and
press >> the
>> >> import button? The excel will be a csv file and
some >> >> values can be also empty or null. Pleas advise me.
>> >>
>> >> Thanks
>> >
>> >
>> >.
>> >
>
>
>.
>
.
Upload the csv file in a folder monitored by a SQLServer 2000 sheduled DTS.
The only step of the DTS is importing the file in the db
Oops, sorry. Then just parse the text using string functions like Split and
Mid
Jeff
"Vishal" <an*******@disc ussions.microso ft.com> wrote in message
news:9e******** *************** *****@phx.gbl.. . As said I will go with the second option and therefore I
cant use the Excel Odbc driver.
-----Original Message-----
Use the Excel ODBC driver to treat the file as another
database.
Jeff
"Vishal" <an*******@disc ussions.microso ft.com> wrote in
messagenews:a8******* *************** ******@phx.gbl. .. I think i will go with the 2nd option. Once the user has
entered the values like this:
1,2,3
4,5,6,
7,8,9
How do I then read it line by line so that I can insert
each line to my dbase table?
Thanks
>-----Original Message-----
>Well, you can either upload the file to the server, or
have the user enter
>the values into your textarea. Your choice.
>
>If uploading, Software Artisans has file upload components >
>Jeff
>
>"Vishal" <an*******@disc ussions.microso ft.com> wrote in
message
>news:9d******* *************** ******@phx.gbl. ..
>> yes
>>
>> >-----Original Message-----
>> >Where is the file? On the client?
>> >
>> >"Vishal" <an*******@disc ussions.microso ft.com> wrote in >> message
>> >news:9d******* *************** ******@phx.gbl. ..
>> >> Hello,
>> >>
>> >> I need to import data from a excel file into a
SQL
>> >> Server. I would like to provide an asp.net interface for
>> >> that purpose. What would be the best to do that? A
>> simple
>> >> textarea where the user can insert his data and press >> the
>> >> import button? The excel will be a csv file and some >> >> values can be also empty or null. Pleas advise me.
>> >>
>> >> Thanks
>> >
>> >
>> >.
>> >
>
>
>.
>
. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Stan Cook |
last post by:
Does anyone know how or what I can use to open, read and extract data from a
dbase database? I haven't found anything of much use with accompanying
documentation.
|
by: Ivan |
last post by:
Hi,
SQL Server 2000 SP3
Windos 2000 Server SP4
I have a DTS package that imports data from a dBase IV databse with
files located in two folders (dBF1 and dBF2). I use a transform data
task to transform the data.
They were running properly, but last week we installed W2K SP4, and
|
by: Java script Dude |
last post by:
For those who are missing the feature on how to import into Open Office
dBase app from text files and spreadsheets in OOO Base 2.0:
A wizard exists to import from spreadsheets only at this time but there
is no menu pick for `importing` at this time.
OOO 2.0 dBase Import SOP:
1) Open the spreadsheet -or- text file as a spreadsheet
2) Select range on spreadsheet you wish to import including title rows
if applicable
|
by: Nick M |
last post by:
Hello All,
Excellent info here Thanks!
I am very new to using access in general and I am on a learning curve.
I'm trying to import an excel workbook (with worksheets) into an access db
via a macro. (I'll get to using VB later on).
What I would like to do is import a single workbook w/three seperate
worksheets into three seperate access tables AND truncate the time stamp
that is used in the excell sheet via a macro.
|
by: Wandering |
last post by:
I know you guys are heavy duty coders, while I do ad-hoc analysis, and
rarely write code. And, I may be in the wrong groups because this is
about an install issue, and I don't think it's a code issue. But ...
Office 2000 was on this machine when it was given to me. I don't own
it. After installing Office 97, mine, in a different directory, and
checking most of it out, I uninstalled Office 2000.
Well, it's a lot easier to upgrade than...
| | |
by: Mark S |
last post by:
I'm basically a database noob hoping to find a shortcut if at all possible.
I've created an ER diagram for a site I plan to build and have used that to
create the database in MS SQL 2000.
Now I want to import various data from (basically) excel spreadsheets (for
example, company names from a different sql dbase, addresses from excel and
phone numbers from a csv file) into the new database.
I have tried various methods outlined on web...
|
by: mtgrizzly52 |
last post by:
I am running an access 2003 dbase that has been slowly developed for use on a network. (I know, should be sql, but our IT dept won't allow that to happen, so we are stuck)
Anyway, because of the extreme turtle's pace of inputting data online, and some other issues concerning liability issues, we have two versions of the same database. The one that is online, and then a version that can be used in the field. Like I said, these two versions are...
|
by: PW |
last post by:
Convert them to CSV in Excel, then use TransferText (which does not
work correctly and also doesn't accept XLS/Excel files directly) or
create a link to an Excel XLS workbook and do an Append Query (as some
have suggested here)??
I find that hard to believe as Access is part of MS Office and Visual
FoxPro is not. I split my time using both and I can do a simple copy
command to XLS in VFP or an Append command to DBF or use Office...
|
by: provor |
last post by:
Hello,
I have the following code that I am using when a user presses a button to import an excel file into a table. The code is hard coded to point to the correct table. This works great for this one table. My problem is I have two buttons I want to use this code for for the two buttons would put the data in different tables. I have tried copying and changing a few things and nothing will work for me. The code is set up in a module and then I...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
