473,326 Members | 2,023 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Help Please - Excel & SQL


Ok, this is what I need to accomplish.

We have a huge excel file that comes in daily. I need the server to grab
this excel file each day and import the data into a SQL database. Once
that is accomplished, I want the web app to allow the user to search any
data in the table. This is overwhelming to me.. I don't know where to
begin. The excel file has 193 fields and tons of records. Any advice on
this would help me tremendously.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #1
2 1227
"John Saunders" wrote ...
We have a huge excel file that comes in daily. I need the server to grab
this excel file each day and import the data into a SQL database. Once
that is accomplished, I want the web app to allow the user to search any
data in the table. This is overwhelming to me.. I don't know where to
begin. The excel file has 193 fields and tons of records. Any advice on
this would help me tremendously.


This would be impossible for me to list all of the code and stuff in one
bash to help you - so instead here are some thoughts - as we have a similar
process here at work.

You'll need to make sure the excel file is in a location that your SQL
Server can access.
You'll need to create a job that runs perhaps a DTS to import the excel file
(I'm assuming its in a .csv or could be etc?)
You'll want to schedule the job to run - perhaps at midnight each day to
bring in the next relevant file.
You'll then need to put the ASP/ASP.Net code together to allow you to search
the results...

I'd suggest that you start SMALL!

You've not said what experience you have with regards to SQL
Server/ASP/ASP.net etc, so its a bit difficult to go much further at this
stage...

Regards

Rob
Nov 18 '05 #2
John:

Check into creating a SQL DTS package to handle (and automate) the excel to
SQL table process. The next step is to full-text index the SQL table in
question to allow you to perform full-text querying on the data. With a
proper full-text catalog created by the full-text index, you can now use SQL
keywords such as CONTAINS and FREETEXT to search the data and return
appropriate hits. There are performance considerations when your data gets
to be more than a million rows.

Check out the SQL Server Books Online for more specific information. You may
also want to create more limited searches based on a subset of fields
contained in the table (a most used feature) for more frequent, performance
minded searches.

Hope this gives you a starting point.

John Sturgeon, MCP, MCSD

BizTech Solutions, Inc.

"John Saunders" <js*******@gsorad.com> wrote in message
news:eZ**************@TK2MSFTNGP11.phx.gbl...

Ok, this is what I need to accomplish.

We have a huge excel file that comes in daily. I need the server to grab
this excel file each day and import the data into a SQL database. Once
that is accomplished, I want the web app to allow the user to search any
data in the table. This is overwhelming to me.. I don't know where to
begin. The excel file has 193 fields and tons of records. Any advice on
this would help me tremendously.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Dan | last post by:
Hello, I am trying to read and write to an Excel file via my Java applet. I have done so successfully on several simple Excel files that simply had data cells without many complicated equations...
11
by: Mr. Smith | last post by:
Hello all, My code can successfully open, write to, format and save several worksheets in a workbook then save it by a given name, close and quit excel. My problem is that if I try and do it...
38
by: Red Dragon | last post by:
I am self study C student. I got stuck in the program below on quadratic equation and will be most grateful if someone could help me to unravel the mystery. Why does the computer refuse to execute...
1
by: | last post by:
The following code: Private Sub ClearControls(ByVal ctrl As Control) Dim i As Int32 For i = ctrl.Controls.Count - 1 To 0 Step -1 ClearControls(ctrl.Controls(i))
6
by: Mark Rae | last post by:
Hi, My client has asked me to provide a "quick and dirty" way to export the contents of a DataGrid to both Excel for analysis and Word for editing and printing, so I'm investigating client-side...
10
by: steve | last post by:
hi i am writing a C program which can read TEXT , PDF,.DOC files the program is to : count the number of words, lines, characters and the frequency of each word and the phrases count in...
23
by: casper christensen | last post by:
Hi I run a directory, where programs are listed based on the number of clicks they have recieved. The program with most clicks are placed on top and so on. Now I would like people to be apple to...
0
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted...
6
by: slinky | last post by:
I found the following code to transfer datagrid data to an Excel file. Is this written in C#?... I'm a vb.netter. I'm just not sure where to place the code to experiment on it. Should I place it in...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.