473,498 Members | 37 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need to get daywise attendance records one below other fro mlinked excel file

1 New Member
I have one excel file containing daywise attendance marked as "P","UPL","LWP",etc for each day & I want access query to give me output having each employee one below other with daywise attendance in single new column for all days
Jan 3 '18 #1
1 1383
twinnyfo
3,653 Recognized Expert Moderator Specialist
KoolKaps,

Welcome to Bytes!

We would love to assist you with your project. However, please refer to the Article about Asking Good Questions and then please also provide additional clarification on exactly what it is you are looking for. You did not provide enough details for us to aid in troubleshooting.

Thanks! Hope this hepps!
Jan 3 '18 #2

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

Similar topics

1
1723
by: Mahesh Kumar | last post by:
hi, I have two excel files(a1.xls and b.xls) each having 4 sheets. I want to read datas of 4 sheets from b1.xls and it has to be inserted in a1.xls as 4 sheets. First it has to delete all datas...
2
12698
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...
1
4607
by: Esmail Bonakarian | last post by:
Greetings all, What is the best way to access specific records in an Excel file? I have an Excel file, I want to randomly and repeatedly (maybe around up to 50 times) draw some rows of data...
1
8150
by: Massimiliano Campagnoli | last post by:
I need to export some tables to an excel file inside a REXX unattented script that run periodically. I've tried the command : DB2 EXPORT TO MYFILE.WSF OF WSF SELECT * FROM MY_TABLE but it...
3
1802
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...
8
10069
by: LimaCharlie | last post by:
Hi, Question pls. I have an MS SQL local package where it exports data from SQL table to Excel file. My question is, how can I erase all the records in my excel file before i export the new data...
9
10205
by: John Bailo | last post by:
I want to generate an Excel file (.xls format) from some database data. I don't want to use Excel.exe because of all the automation and security issues. Does Microsoft document the .xls file...
2
4980
by: cckelly | last post by:
Hello, all! I need help. There is a "view" in a SQL Server 7 database that contains all the data I need. I want to create an Excel file (version Excel 2000). I want the file to open the view and...
1
1778
by: farhana | last post by:
Hi experts, Need ur help and advice, My excel file is for user to upload their product listing. I have created a macro programming in the excel file. To use the file, user need to download...
3
2835
by: kishore123 | last post by:
I have created an Excel file using PYExcelerator API. I need to programatically password protect the file so that it can't be read unless the password is entered. working in Linux environment. ...
1
6884
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...
0
7375
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5460
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4904
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
4586
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3090
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1416
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
651
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.