i am having a folder which contains 100 files and each file contain the columns separated by the ' |(pipeline)' and similarly that file contain data also.so i need to bulk upload this folder to the ms sqlserver2005 so that automatically these tables with data added in the database so how to do that one? tell me if any store procedure or the any asp.net program is available for that.
View 1 Replies
When I try to upload excell to table as bulk on server 64 bit
the error show
(its work on my pc but when i publish it on server error shows)
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
I suing this code to upload csv file data to sql table.
BULK
INSERT uploadtemp
FROM 'F:ArruniArruniRaj-NathanSchoolcvsparents_with_pupil_adm_nos.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '
'
)
END
After i upload data each and every data inside double quatation like
"Mr J and Mrs P Abbott"
"Abbott"
"Gemma"
"N00390"
"Olivia Abbott"
"N00595"
"T"
How can i upload data without " . And also i want start upload data start from second row. How can i do that? [URL]
Im using a file uploader to upoad files to a folder used for upload.But the problem is this folder is a linux folder. I have made it a shared folder so that I can access from windows by samba. So, file transfer is successful when I'm using os but when I try to upload something from my websites uploader to this folder, this process is not successful. I have given all permissions to this folder.Don't know whats the problem.I have used both type of slashes for directory but still it is not successful.
View 4 Repliesi am trying but i am unable to do this one.
View 2 RepliesI have table from following structure
CREATE TABLE [dbo].[tblChildTest](
[ChildID] [int] IDENTITY(1,1) NOT NULL,
[DOB] [datetime] NOT NULL,
[AdmissionNo] [nvarchar](100) COLLATE Latin1_General_CI_AS NULL,
[FirstName] [nvarchar](100) COLLATE Latin1_General_CI_AS NOT NULL,
[LastName] [nvarchar](100) COLLATE Latin1_General_CI_AS NOT NULL,
[Imported] [tinyint] NULL
) ON [PRIMARY]
I want upload csv file data using sql bulk upload . ChildID is autonumber , so i want start data upload from second column. i want omit childid and start from DOB.
I have another question concerning the bulk insert. I am doing a bulk insert from a text file like (delimiter is | and I have 2 columns):
1|12334
2|23232
How can I check if the user has a file like:
1|12234|2323
2|23233
I mean how to check the wrong columns numbers.
This is my format file
8.0
5
1 SQLCHAR 0 0 "," 5 LastName ""
2 SQLCHAR 0 0 "," 4 LastName ""
3 SQLCHAR 0 0 "," 2 DOB ""
4 SQLCHAR 0 0 "," 3 AdmissionNo ""
5 SQLCHAR 0 0 "
" 7 Reg ""
This is my Sp
begin
BULK
INSERT tblChild
FROM 'F:ArruniArruniRaj-NathanSchool-DocPupils.txt'
with
(
formatfile = 'c:format.txt'
)
end
This is my table structure.......
I want to Upload bulk images from client to server using web service...
I already create web service for uploading images but it does not support well.. i have used byte array for that..
i used database sqlserver2008 and i make website which have database on internet serveri get ip address and username and password for that databse ;it's sqlserver 2005i want to upload database to my website ; i conccet with it by sqlserver managament 2008 ;then when i attachment database i get these messagemicrosoft.sqlserver.management.sdk.sfk how can i solve this error
View 3 Repliesi am trying to upload files through the ASP.NET File Upload control.
Every thing is working fine, except for the fact that when i try to upload the file on the server i am getting an error: (probably some authorization exception).
do i need to give some rights to the upload up there on the server. If so then for which account and do i need to restart the server after giving rights?
I want to allow a user to upload several files with one upload action. What is the simplest way to do this?
View 3 Repliesi'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]....
i am using file upload control to upload the files in asp.net with vb.net as code behind. am storing the files in my local drive. my doubt is, how shall i read those file using asp.net application.
View 1 RepliesI have a requirement where i need to upload mulitple files with one file upload control. I googled and found ajax uploader control but should be paied to use that. Is there any control similar to that which can be get at free of cost or could any one provide me sample code how can it be done.
Actually i have to upload car images and bike images to respective folders say carfolder and bikefolder. I used two fileupload controls one for car and other for bike and one button. when clicked on button the following code executes to upload the files
[Code]....
I'm new in ASP.NET , I finished one website by ASP.NET with Visual basic (2008), It's contains 2 files (Default.aspx & Thanks.aspx). The Default.aspx is main page. Now I want to upload them on server. I already have space on one server.
I did publish web site then the Visual Created one folder is PrecompiledWeb contain other folder with the same project name inside it these files (App_LocalResources , bin ,images , Default , PrecompiledApp , Thanks and web) , I uploaded these files on the server in www folder. but it's is not working if I will enter in the web browser my website name. How I can config the website to work when I will enter my website name like this(www.xxxxx.com).
I am using a upload control to upload files and that works. But I want to see what files I uploaded.
View 2 Repliesi want upload zip and rar file to server and download it and audio and video file also.
View 1 RepliesHow do I allow users to upload files to a subFolder under the root web folder?
1. Display a list of filenames of file type (.doc, .txt, .pdf) on one webpage(ListOfFiles.aspx).
2. Make those filenames hyperlinks so that when clicked on, the file is displayed in the browser.
3. Have another page(Admin.aspx) that allows the user to upload and delete those files residing in that subFolder.
I am unable to upload even 75MB file ... it seems MS for some good sake is putting a limit of the file. how can I overcome this issue.
View 12 RepliesI need to create an upload site to upload large files over 2GB I want ot create a site like [URL]. Once these files get upload i want them to have a link to the file created but the link encrypted. I know there is a limit to http upload. I have used a bunch of the flash upload web apps but are capped at a specfic mb becuase of .net. What options are out there.
View 2 RepliesI have to create a web app (in C#) that's gonna let my users upload their files straight to Amazon S3 (not enough bandwidth on our own server). It looks like the only way i can do that is posting a simple HTML form to Amazon. The problem is that i have to do some work on my server too, like renaming the files, setting up flags on db when file is uploaded, and so on. I really can't see how to do that without uploading files first on our server, which is out of question, so other solution for this? Amazon S3 forum is pretty poor on this topic.
View 2 RepliesI am using this link
[URL]
Now my requirement is Multiple file upload code should be in the usercontrol but when click in the btnSubmit from aspx then it has to upload in folder and has to get save in DB Table.
How to do this? Is there any easy way to do this?
[Code]....
I'm trying to upload multiple files, so my first componet consist of a user control with an upload multiple files class:
[Code]....
After compiling I get the following exception:
Failed to set the specified COM apartment state
Is there a way to overcome this exception to upload multiple files?
Are there any code examples out there that allow a user to select multiple files or even an entire folder for upload?
View 2 Replies
