sending excel file to SQL server table -
Hi
I have about 360 excel files,each excel file contains up to 500 rows.
I want to send the 360 excel files to a single SQL server table(in another words,the SQL server table should contain all the 360 excel files).I want to developp a VB6 project that send an excel file upon clicking on a command to the table,how can I send an excel file to an SQL server table?
Thanks
sending excel file to SQL server table -
Hi
I have about 360 excel files,each excel file contains up to 500 rows.
I want to send the 360 excel files to a single SQL server table(in another words,the SQL server table should contain all the 360 excel files).I want to developp a VB6 project that send an excel file upon clickin
How to import data from MS Excel to MS SQL-Server database by ASP -
How to import data from MS Excel to MS SQL-Server database by ASP.
For example, already added a long list of contact people (name, phone, email, address...) in an excel file, how can I just upload the excel file to transfer the data to a table on the MS SQL-Server by ASP code?
An
Send files to server using FTP -
how can i send a new file to a server using FTP in VB.NET.
i need to try sending new files to server using FTP. after sending i can delete from server,rename,update the file etc.
first i need to make a connection to server and try sending new files(that's file not present in serv
Export an Excel Sheet in a SQLServer Table -
Hi guys.
I have to do an application that export programmatically an excel sheet on a SQLServer Table. I cannot launch DTS because clients are not autorized to write file on the server. My excel files should contains more then 10.000 rows, then to do an Insert query for each row of
Excel, VB, SQL Server Problem -
Hi!
I want to be able to update SQL Server from the excel spreadsheet, using VB Program.
The Excel range will be selected and the columns in SQL Server Table should be updated according to excel columns.
Can somebody please help
Select Excel files and import to SQL server 2008 express table -
Hi,
Does anyone has a sample code that do like,
Open and select excel file and select the exact excel sheet to import then connect to SQL server 2008 and append all the data from the certain sheet to the SQL table?
Thanks.
winsock send multiple client -
dear pple,
i wrote a server program which sits in a computer and listens to an incoming connection. i have a send file function in a module. whenever a client connects, this server will send a file to this client.
so if client1 connects, server will send to client1 and if client2
Copy table from Excel and paste as html -
I'm sending an email via SMTP and I want the HTML content of the email be the table from an excel document. I want to preserve the look and feel of it by converting it to HTML somehow....
how would i do that? (ie given a selection in excel, convert it to HTML?)
Open Excel from server in client's browser using VBScript -
Briefly:
I'm trying to open an Excel file taken from the server and modify it on the client' side using VBScript without ASP. Does anyone know of a good way to get the Excel file to the client?
Details:
I would like to send the Excel file along with the web page with the VBScript
.Net Creating Pivot Table programmatically -
Hello,
Firstly I am programming this in .Net, I thought this would be the best place to post my question since I am trying to use Excel services at runtime.
Mods: if you feel this isn't the right place for this post, please move it to an appropriate forum.
OK, I have 2 OLAP cu
copy data from excel sheet to access table through vb or vb.net coding -
hello
I have 15 excel file with same no coloma , i want to convert this file in access file(database) table which contain same no of colomn in excel file through coding.so the all date of 15 excel file will be store on single table of my access database.
Converting Excel Data to MDB -
Hi All,
I have to convert Excel data to MDB.
User will select Excel file and on convert button click the data from Excel should extracted to MDB file. Already I have an MDB file in that I have created Table as TEST1, From Excel I have to extract data of one column to MDB..TEST! tab
Appending Excel file into Access table -
Hi everyone,
Trying to figure out what is the best way to accomplish this using VB.Net. I have an Excel workbook with two sheets. The second sheet contains the 6 column headers along with all the data. We keep this Excel file saved on our system. So I have two options (I think).
HELP to export data in excel from sql server table -
Dear friends
I m using vb.net 2008. I have created an application in which data is needed to be exported from sql server 2005 to excel sheet. i do not know that how can i export data from the sql server table to the excel sheet.
Plz help me.
Thanks in advance
Shiv
Do I need to install Excel inDatabase server -
Hi , Can anyone help me in this regard...
My system works on ASP as front end and Sql server2005 as backend. The database server and file servers are on different IPs.I have written a package in which several stored procedures are there and some of them operate microsft excel to gener
Moving excel data using VBA into SQL server 2000 -
Hi
as mentioned in title i'm trying to move data from excel into a table in a sql server 2000 database. We have spreadsheets that produce data in excel using querytables.
we want a system the other way, by typing data into a spreadsheet, pressing a button which pushes the data i
Open OLE Object From Table...Urgent!! -
I have an Excel File in a a table...
How can I open it from Code!!!????
Driving me crazy!!
Basically I need to open excel...load the file from the table...populate it.
Access 2000
(I could do this if the file were anywhere else like on the C Drive...but This time the fil
Help on sending files with winsock. -
Hrmmmmm... Here's the deal. I made a connection (using client to server software I programmed) on port 1000 with winsock. I'm trying to make my client send a file to the server. Sending text is simple but sending files is proving more difficult. Can someone give me an example that work
Export large sql table to excel -
Hi all,
need ur help with this guys. I need to export a table in sql server unto an excel spreadsheet. The table has dynamic columns and keeps on changing. have tried using dts but it gets an error everytime i change or delete a column. can't use those examples in this forum coz mos
Return Excel sheet from Server to client -
Hello,
I am trying to show a report (in Ms-Excel format) in the client-side - but have the excel file in the server. I have a DLL that opens the Excel file and returns the same to the client. The problem is that the report is opened in the Server instead of in the client. Can anyone
Sending data to Access DB from Excel -
I am still a n00b to using access with Excel so I need some help here.
I want to have like a system where users can sign up via the spreadsheet. They fill in 5 different pieces of information then click the submit button. This then sends it to the Access database to a table called M
Any SQL Guys -
I'm using ADO.NET and VB.NET to write some data out to a SQL Server Table. basically I am stepping through a DataTable and Inserting each row into a SQL Server Table. Well when I am done, and look at the table in SQL Server, the number of Rows it says it has is wrong (short a couple hu
export a excel to SQL server -
I have an excel worksheet that has the following columns:
AID
CustomerID
CollectionID
TypeID
AgentID
Date
Special Instructions
and i want to send it to an SQL server table "Collection" that has the same fields:AID,CustomerID,CollectionID,TypeID,AgentID...
My proble
Winsock: Getting more than I'm sending -
I have a file sending program and it appears for some reason that I'm getting more than I'm sending when sending a 2841675 byte file I receive 2844012 bytes. Is there some kind of EOF thing being sent at the end of the file?? if so how big is it?
Calling exe on windows server -
Hello All,
I have developed VB program which opens an excel file and read multiple sheets and converts them into one excel file and save as csv file.
program will invoke excel workbook by using createobject('Excel.Application');
Program is running fine and giving me desired re
how to deploy excel app to server without MS office -
Hi There
I am writing a program in vb.net to read data in an Excel file.
The program works file in my PC but not in a server. My PC had been installed Excel 2003, but the server has no any MS Office.
To install my application in the server I generated a setup.exe and msi fil
How do you display an excel 2007 Table in VB 2008, Please help :( -
I created a table in Excel using excel 2007's Table feature, with the numbers 1 - 5 in one column, and a number of food products in the second column, easy enough, but now i have to display that table with it's gridlines, in VB2008, how do i do this?
2nd question
I created a text
[2005] creating excel files on server -
I need to create and save excel files to a folder on the server, not just display them in a browser.
Must you have excel installed on the server or is adding a refrence enough ?I'm getting a "com" error.
If I need to install excel on the server I concerned about licenc
Excel columns number -
hi,
i am developing an application in VB6 which must
extract some excel datas into a table
the problem is that the excel sheet may have
one or multiple columns and I have to populate the
table accordingly
the table part is OK but I don't know how to
check how
Sending faxes with Rightfax via VB -
Does anyone know what it takes to send a fax via RightFax using VB? We currently use different software (Fax Sr.) for this process and use VB to smash an Excel spreadsheet and a text file together via DOS commands. Then dump the file in the Fax Server queue. The queue is simply a di
Import excel worksheet into access table -
Heres the deal....
What I want to be able to do is import an excel worksheet into an access table. I know that you can do this by going into access and import the .xls file that way. But what I would really like to do instead is, within my application, be able to select the .xls f
Run an excel app on a web server -
I have a complex excel application, that I need to run on the server, called by an ASP page.
I want the app to run and save the result on a shared folder. The end user then can open the excel file after completed.
1) Can this be done with out running excel on the client?
2) How woul
importing excel into sql sever 2000 table -
i have a large buffer error while importing a an excel file thru DTS
my excel file has a large data on some row (more than 255chars).
i have created a field that i know can accomodate the length of this chars.
but when i import this file to sql server 2000 it gives me an error.
Check to see if Application is buisy -
I need help, When I am constantly sending data to excel from another application. but when i edit a cell and I stay in the edit mode for too long, a message pops up saying the server is buisy. Is there any way I can check to see if Excel is curently buisy before sending the data?
Alterante ways to send Mail from VB6 (to users who uses MsOutlook) -
Hi,
I created a VB6 applicaton. This application opens a excel file, update and close the file. Through Task Scheduler i assigned this applicaton to run everyday 6:00 Am and its working fine.
I tried sending mails from VB6 by using Microsoft Outlook & its working. But
transfer -
In VB 6.0 I have two code which do the following using a DTS package in sql server 2000
1) transfer data from a text file to a sql server table
2) transfer data from an excel file to a sql server table
Now I would like to do the same in vb.net.
I was thinking may be there is no n
Winsock - Sending files -
Hey,
I know how to send data using winsock.. but how would I send a file?
Basically I need some way to display a progress indicator (e.g x out of x kb transfered) while sending a file from the client to the server, then the server would save the file in a certain location.
It
Export Table to Excel -
Hello there,
does anybody knows how can I export a SQL table into Excel using Visual basic. I want the data from an SQL table to be exported to an excel file or spreadsheet using VB.
Thanks in advance.
Writing a databse table to an Excel file -
Hi Everybody, I am writing a database and in some point in the program the application should generate an excel file. The excel file should contain the database(Table) materials. How should I achieve this. I am using Data control
VB .Net & Excel Reporting -
I have created some Excel templates and an EXE that opens them, get data from a DB, writes it and saves it. It works great on my machine because Excel is installed on it.
I need to move the code to a production server where excel is not running, what are my options? I am making us