read excel file

[voroojak]

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

thanks
Voroojak

[PianoMan64]

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

thanks
Voroojak

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.

[voroojak]

HI
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.


thanks
voroojak

[NeoPa]

In that case I would consider linking the spreadsheet as a table.