Hello,
I nee to write something that will transfer excel data into an SQL Server
table.
I have for another database application I wrote have it importing Excel
spreadsheet data using cell by cell, row by row method. This is fully
automated so the user can choose whatever spreadsheet they want to import
and press a button which sits on a VB6 frontend.
This has been good for that situsation but it can be very slow when there
are large amounts of data to process.
I am just wondering are there any faster, better alternatives that would
still enable a user to select which excel spreadsheet to import
as the application I am writing now will sit on a website frontend, using
ASP, and I'd really like to try and speed things up if I could.
any advice would be much appreciated.
Thankyou,
Oh, and hello, this is my first post here!
Jayne 4 4654
Little PussyCat wrote: Hello,
I nee to write something that will transfer excel data into an SQL Server table.
I have for another database application I wrote have it importing Excel spreadsheet data using cell by cell, row by row method. This is fully automated so the user can choose whatever spreadsheet they want to import and press a button which sits on a VB6 frontend. This has been good for that situsation but it can be very slow when there are large amounts of data to process.
I am just wondering are there any faster, better alternatives that would still enable a user to select which excel spreadsheet to import as the application I am writing now will sit on a website frontend, using ASP, and I'd really like to try and speed things up if I could.
any advice would be much appreciated.
Thankyou,
Oh, and hello, this is my first post here!
Jayne
DTS Packages are design just for this sort of thing.
Zach
nib <in*************@nibsworld.com> wrote in message news:<2t*************@uni-berlin.de>... Little PussyCat wrote: Hello,
I nee to write something that will transfer excel data into an SQL Server table.
I have for another database application I wrote have it importing Excel spreadsheet data using cell by cell, row by row method. This is fully automated so the user can choose whatever spreadsheet they want to import and press a button which sits on a VB6 frontend. This has been good for that situsation but it can be very slow when there are large amounts of data to process.
I am just wondering are there any faster, better alternatives that would still enable a user to select which excel spreadsheet to import as the application I am writing now will sit on a website frontend, using ASP, and I'd really like to try and speed things up if I could.
any advice would be much appreciated.
Thankyou,
Oh, and hello, this is my first post here!
Jayne
DTS Packages are design just for this sort of thing.
Zach
I second that notion -- however, there are some problems with
importing Excel data into SQL Server.
I've noticed that if you have a column whose first value is numeric,
and then there are other values in that column that are not numeric,
those values get dropped. Kind of a pain. DTS Packages are design just for this sort of thing.
Zach
I second that notion -- however, there are some problems with importing Excel data into SQL Server.
Will a DTX package still be as flexible as what I am doing now,
i.e. would a user still be able to browse through a VB6 / webfrontend to the
spreadsheet they want to import,
i.e. can it be coded in VB6 / ASP? I've noticed that if you have a column whose first value is numeric, and then there are other values in that column that are not numeric, those values get dropped. Kind of a pain.
There are loads of problems with importing excel into sql server, I've found
if the spreadsheet is not set up as a text format data then strange things
will happen.
Similar when you export from sql server to excel, leading zeros of numeric
data gets dropped etc...
Anyway,
Enough of that, thanks
Jayne
Little PussyCat wrote: DTS Packages are design just for this sort of thing.
Zach
I second that notion -- however, there are some problems with importing Excel data into SQL Server.
Will a DTX package still be as flexible as what I am doing now, i.e. would a user still be able to browse through a VB6 / webfrontend to the spreadsheet they want to import, i.e. can it be coded in VB6 / ASP?
You'd have to investigate exactly how much you can do with it. Even if
DTS requires a hard-coded file name, you could always have your front
end copy the chosen spreadsheet to said name and then run the dts package.
Zach This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Edward S |
last post by:
I budget for a Project in an Excel sheet as illustrated below. The
months below are usually a 2 year period i.e. 24 months, though it
could be over 24 months depending upon a Project. I then...
|
by: Darren |
last post by:
I have been attempting to create a reservation planning form in excel
that imports Data from an Access database and inserts that information
automaticly into the correct spreed sheet and the...
|
by: Snozz |
last post by:
The short of it:
If you needed to import a CSV file of a certain structure on a regular
basis(say 32 csv files, each to one a table in 32 databases), what
would be your first instinct on how to...
|
by: hharriel |
last post by:
Hi,
I am hoping someone can help me with an issue I am having with excel
and ms access. I have collected data (which are in individual excel
files) from 49 different school districts. All...
|
by: John Overton |
last post by:
I have a new requirement to Import and Export Excel tables into and out of Access 2003. The Excel tables are located on a remote server but I know the path to the Excel Files.
Can you please help...
|
by: zamzoum |
last post by:
hi
i just wanted to ask u how can i solve the exception error "couldnot find installable ISAM"
this exception occurs when i run this code :
Dim excelConnection As...
|
by: scoots987 |
last post by:
What do others do if you need to import excel files into SQL Server?
My main problems are
1) zipcode formatting issues. If the column is a mix of zip and zip+4,
I have problems retrieving all...
|
by: upadhyayanuj |
last post by:
Hi I have an error while uploading file and then importing it into my sql table
The process cannot access the file 'c:\inetpub\wwwroot\FlowLine\Excel File\Fan_Details.xls' because it is being...
|
by: alvinstraight38 |
last post by:
Hey guys,
I am trying to import data from an Excel spreadsheet into my SQL
database. I am running SQL 2005.
I following Microsoft's instructions for creating a linked server, and
it appeared...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |