DataSource Controls :: Best Practice For Importing Files.xls Or Files.csv To Database?
Apr 16, 2010
I need to populate a database (SQL Server) with some data from a templated excel document.Here are some approaches:
A) User upload a file.xls or file.csv that the server reads, checks and updates the database (cons:the uploaded file might be too big. file.* needs to be in correct format)
B) User downloads a tool.exe to read and upload file.xls (cons: maintenance of the tool.exe)
C) Use of a web service in excel? (don't know how to do it) but
this article might give you a hint
Which one is the best to use? Are there any others?
View 4 Replies
Similar Messages:
Jan 27, 2010
I am getting the error while importing the dbf files to access database.It giving "External table is not in the expected format"
View 4 Replies
Aug 6, 2010
I want to upload some large files from a web page to MS SQL Sever database, I am very sure that it is sounding weird.
File sizes are around 100MB.
I am having following settings,
SessionTimeOut period = 60 Mins,
Server Operation timeout = 60 Mins,
SQL Connection Timeout = 4 mins (Not sure if this is helping)
This is page is going to be used by our client only once a week & as they are having web farm environment we are avpiding to store these files on file systems.
Currenty we are able to upload files with sizes upto 8 MB succesfully. But when we are uploading a file of 100MB it fails, its for sure that operation takes lots of time.
View 4 Replies
Mar 19, 2010
my problem is my asp.net and C#.net application should read flat files(.txt,.doc) from folder automatically and read the data from file and stored into database
my file like this :
BNK20100312APPHU6658994 // BNK,20100312(date),Ap,PHU6658994 So we have to store these..
BNK20100312APPRU5104220
BNK20100312APPRU5761800
BNK20100312APPZU3739288
BNK20100312APPZU4454037
BNK20100312APESU2552894
BNK20100312APAXU4302543
BNK20100312APCKU1613369
View 1 Replies
Feb 11, 2010
I just created a component management system.. I would like to share files and folders among users from a database. Actually i couldn't do that.
View 1 Replies
Mar 17, 2010
Ms SQL 2005 database I have a empty database at my hoster site. Its has nothing in it period. The admin's of the hosting site (asp.net 2.0) said send them a .bak file. .bak files are from "generate a backup" of a database in TOTAL. So I can see how a .bak file can restore a FULL database, but what about changing a stored proc?? Q1: The hoster admins only want .bak files to do tweaks to my database, so how does a .bak file acheive this for a just adding a table or a store proc only ? Q2: Some tables had data in them on my localhost, is there a way to generate a INSERT script for each data row and run this code at hoster site, or do I have to do an EXPORT from my localhost and an import at my hosting site?
View 7 Replies
Jun 14, 2010
Is the classic way of using include files still the best practice in ASP.NET. IS there a better way in ASP.NET to simulate include files? IF not can someone please provide an example of the .NET way?
View 5 Replies
Nov 21, 2010
I am working on my first ASP.NET Website using VWD and C#. I did some inital design with Expression Web 4 such as created a master page with 2 content place holders, 2 style sheets 1 for the layout and 1 for the nav menu, and some images in a folder. I started with an empty ASP.net site opened my masterpage and saved it to the VWD directory. Now my Solution Explorer contains a MasterPage and a webconfig .cs file. I would like to import the style sheets and images I mentioned earlier but I am not sure how to accomplish this. do I have to open and save as all these items or can I impot them? Do I use the ADD NEW Item command?
View 3 Replies
May 21, 2010
I have this code
Dim myDataset As New DataSet()
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & "dynamicuploadedLists" & strFileName & ";" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited(,)"";"
''You must use the $ after the object you reference in the spreadsheet
Dim myData As New OleDbDataAdapter("SELECT * FROM [" & table & "$]", strConn)
'myData.TableMappings.Add("Table", "ExcelTest")
myData.Fill(myDataset)
And I am getting the error , while the path is correct.
'E:missitenamedynamicuploadedListsSheet1.csv' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
View 3 Replies
Feb 1, 2010
i've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
View 1 Replies
Jan 20, 2010
I creating a page where our clients can view advertising images and then able to download the images in different file formats. So I need the images and the different download types all saved into the same row in the database so that when I go to display them on the page when they select a picture the right download links will be there. So here where my problem comes in, I don't know how to code it so that I can insert mulitiple file paths into the database at once. The images are saved in a table called images. The downloads are saved in a table called Image Downloads.
Here is the code for the page I have it coded to submit the images to the database but not sure how to add the rest. I have got three different sql datasources for each table not sure if that's the way to go.
[Code]....
View 1 Replies
Jan 30, 2010
how to store files (pdf and word files) into sql database and how to display that files with an option of "save" , "open" window from sql data base when user click. i am doing project using c# + asp.net web application
View 1 Replies
Apr 24, 2010
how to import data from notepad to sql database.
View 1 Replies
Mar 18, 2010
My prob Is I have Excel files in my folder i need to Store the Records into Database Table. iam using VS.2005,c#.net,Asp.net ,Mysql 5.0
View 1 Replies
Sep 28, 2010
in my project i would like to save pdf files in database, how to save pdf files in database ? along with that i would like to create create a search page to search for pdf files with PDF file names , how to accoplish these things
View 3 Replies
May 14, 2010
Requirement:I need to poll the folder (which is in my web application) lets say for example UploadDocs. i want 1 SQL JOB that will run periodically to check the new arrivals in this folder. I know how to create sql jobs but dont know how to do sql logic.
View 1 Replies
Apr 1, 2010
I'm trying to import a file. It's been importing from VFP just fine but just yesterday, it stopped working and I'm getting the following error message. If this is referring to my registry, there is no such entry in my registry. Do I need to re-install?
Error 0xc002f210: Preparation SQL Task 1: Executing the query "" failed with the following error: "Retrieving the COM class factory for component with CLSID {19E353EF-DAF4-45D8-9A04-FB7F7798DCA7} failed due to the following error: 80040154.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. (SQL Server Import and Export Wizard)
View 1 Replies
Apr 23, 2010
I want to restore .bak files from a server directory into database. The problem is it should behave automatically. Whenever a .bak file will be uploaded in that specified directory of the server that file will be restored. It may happen by using sql procedure which will restore all the .bak file which it will find at a certain time in that specified directory. Or, it may happen by using asp.net program which will run exclusively on server and call a sql procedure to restore a backup file whenever a backup file will come in that specified directory. But I am not getting how to figure out this ideas programetically.
View 2 Replies
May 27, 2010
I have this code to upload .xls files to sql server and am wondering what I need to change in order to upload comma delimited .dat files.
Dim connString As String = ConfigurationManager.ConnectionStrings("xls").ConnectionString
'Declare Variables - Edit these based on your particular situation
Dim sSQLTable As String = "tempContainer"
Dim sExcelFileName As String
[code]....
View 2 Replies
May 10, 2010
I'm able to upload and read any excel file to my server prior 2007, when I try an 07 Excel file, i'm getting the following error message:
'microsoft.ace.oledb.12.0' provider is not registered on the local machine'
do I need anything specail on the web server to allow for Excel 07 files? I'm running IIS6 and a Win 2003 server
View 1 Replies
Mar 16, 2010
iam Working on Asp.net Web apliation using c#.net, in system folder (Ex: E://Santhu) i have few Flat files and Excels Files .So My Application should read those files automatically and should store the data into my database..
View 1 Replies
Mar 6, 2010
[Code]....
and i found it, here http://forums.asp.net/p/1480079/3451771.aspxi can fairly easily code for a general dbase (name, address, etc..)my question here with this code is...where does my dbase info go?
my dbase info
dbase name = files
tablename = fileTable
column names = fileOne, fileTwo, fileThree
the file upload object is called "fileupload1" and this all goes with a "submit" button
also, that is pretty much for one file, what if the user is uploading more than one file? do i just add more if/then statements, one for each fileupload object?
View 3 Replies
Jan 4, 2010
I used SQLMetal to generate a DBML file, which worked fine. The problem is that since this DBML file is so big (185,000 lines at 840Kb) it takes literally hours to load in VS2008. What is the recommended way to resolve this? I tried using a third party tool call SqlMetalInclude to break the DBML up into multiple data contexts, but that tool generates only designer.cs files, not dbml files.
View 2 Replies
Mar 17, 2010
My apps required me to store upload files into SQL binary fields. And then allow users to retrieve the files and either chose an apps to view them or save on disk. These files can be in diff formats, not just one type.
I have been reading about using the Response.ContentType method and Response.AddHeader method. The issue is the users can upload anykind of documents, ie: MS words, Xcel, JPEG,TIFF.... So at the time of downloading, I have no way of knowing that type it is to put in the Response.ContentType.
Can't I just stream it to the browser, let the download dialog box handle the type selection? as in when you download a file, the dialog box would ask if you want to select an app to open the file or save it on disk. How would I do so ?
View 1 Replies
Apr 30, 2014
<div>
<object data='<%=this.Path %>' type="application/pdf" width="500" height="500">
</object>
-------------------------------------------
public string Path { get; set; }
protected void Page_Load(object sender, EventArgs e)
{
// You can also display the file path from the Database
this.Path = "Data/AppleEbook.pdf";
}
How can display the file path from the Database and another think that my file is also store in Database.
View 1 Replies
