473,388 Members | 1,375 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > asp.net > questions > upload excel file data to multiple tables

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

Upload excel file data to Multiple tables

45
Hi All,

I have this tables.I want to upload excel file data to multiple tables.

Excel file consist of EmpName,1 week dates with data(TimeIn and TimeOut).
I want to insert EmpName into Employee table based on that i will get ID and i want to insert date into Timesheet table and corresponsding data into same table.

Can u tell me how to acheive this.

Emp-EmpNo,EmpName,CompaignId
Timesheet - TimeId,EmpNo,Date,TimeIn,TimeOut
Calcultion-CID,TimeID,WeekStartingDAte,totalHours
Sep 16 '10 #1
0 1355

Sign in to post your reply or Sign up for a free account.

Similar topics

1
How to read the correct data by c#after user change excel file data?
by: Napo | last post by:
Hi I use a c# method to open an excel file and to read it's data.But i find a problem that if i changed the excel file data manually by using excelapplication,the readed data by c# method isn't...
C# / C Sharp
2
Excel file data import to Sql server 2000 via the asp.net
by: Sreedhar Vankayala | last post by:
Hi, I joined a project where we need to import data from a excel file into sql server via the asp.net. After doing a long research found that #1. Upload Excel file to the server #2. Load or...
ASP.NET
0
upload excel file and get data from it
by: powerranger | last post by:
I wrote an asp.net application where I can upload an Excel file to the server and get the data from it to display on my datagrid. The program compile without error. The file loaded on the server...
ASP.NET
1
upload excel file into sql server
by: vic pahilan | last post by:
hi, pls need help. I need to upload excel field to sql server field. the user will choose excel file then i will show the fields inside that excel file then copy it into sql server field. I...
Microsoft Access / VBA
3
Importing excel file data from user's computer
by: Miguel Ramirez | last post by:
Hello all, Is there any way to import an excel file data from user's computer? I want to read all records in the excel file and write the data in a SQL server table. Any help will be really...
ASP.NET
3
allow people to upload excel file to asp program?
by: c676228 | last post by:
Hi everyone, I will develop a program to enroll a group of people on-line. Since we don't have number limitation for the people in the group. I am wondering if there is any company allow people...
ASP / Active Server Pages
3
how to extract excel file data into text file.
by: gujarsachin2001 | last post by:
Hi friends, I m just stuck with extracting excel file data into text file. So can any body please help me out. thx, Sachin.
.NET Framework
0
validation of excel file data
by: vimal.424 | last post by:
hi..... i want to know when we upload the data in excel file so at the time of uploading how can we validate the data in c#
C# / C Sharp
0
how to upload Excel file 2007
by: minhtran | last post by:
Hi all I have a problem when I upload the Excel file 2007 (file.xlsx) via ASP.NET (VB.NET, C#), but it has no problem to upload the Excel file 2003 (file.xls). Please, anyone can help me to solve...
.NET Framework
5
Export data from Excel to MS Access
by: priyammaheshwari | last post by:
Hi all, I have a MS Access database in which requests made by people is stored,but a coulmn for cost is left empty which is suppose to be populated by the administrator.Now the administrator wants...
ASP / Active Server Pages
0
Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
General
0
Batch import of multiple excel files into the database
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
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
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
0
How to build RAID in BIOS?
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...
Computer Hardware
0
Changing the language in Windows 10
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...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
The easy way to turn off automatic updates for Windows 10/11
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...
Windows Server

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.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!