By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

read excel file

P: 92
I have an excel file and i want to use it as input file.
how can i read an excel file?

May 13 '08 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 374
I have an excel file and i want to use it as input file.
how can i read an excel file?

This is all going to depend on how the Excel Sheet is formated. If it is a list of entries that have the first row of each column with a header, then you would be able to either Link or Import the data into an access table within the database. If it is some other format were you're looking to read specific cells within a worksheet within a workbook, then that is going to involve a great deal of VBA programming where it would be a great deal easier to program the form in MS Access and a lot easier to maintaine.

If you could provide more detail as to what you're trying to do and can give you a more detail answer, but without any more information, that makes it kind of hard to give you a solid answer.

Hope that helps,

Joe P.
May 13 '08 #2

P: 92
Thanks for quick answer
It is an excel sheet with the header. i also prefer to be in a coding in vba that i can read the file and then do the calculation.
the excel sheet has 4 columns that the first coumn is the name of the sales person. the second column is their code, the thiord column is each time they log in and log out to their system.
so for example my excel sheet is like that

alex 567 8:10 am 8:50 am
alex 567 9:00 am 12:00 am

i have to fond out their time that they were available in their system and find out that they were following their timesheet or not.

May 13 '08 #3

Expert Mod 15k+
P: 31,494
In that case I would consider linking the spreadsheet as a table.
May 13 '08 #4

Post your reply

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