data in an excel spreadsheet

[Wesley Morgan]

I need to get data from an excel workbook and create a table in access.
The customer is keying in data from a handwritten log each morning into excel. The excel is in a template that increments the pointer to the next row after each entry. Information entered is a value recorded each hour and this value is all that is entered. The times are static in the template. The person then saves the report using short date .xls [ example: 09.03.03.xls for saved file on Sept. 3, 2003]
I need to group this data with an access database so that the date of the file is linked to other tables and allow this value to be included in report that is printed. Tables in db have data logged each hour also and the excel data would match the times also.
Anyone willing to help
Thank you,
Wesley Morgan

 

[namliam]

For 1 thing... Please tell me they are not actually using the points as in your example?! 09.03.03 !!! Bad habbit, break it/them!!

I am sure you know how to import an excel file. Once you have that (without the date in it) run an update on all where the date field is null to the date from the filename...

Regards

 

[Wesley Morgan]

The points are there. I agree this is a bad habit.
I am trying to use TransferSpreadsheet to import the data.
Each file has a different name for the respective date and then I need to force an operator to specify date and then select transfer.
Thank you,
Wesley Morgan

 

[namliam]

you can obtan the names using the dir command or using a dialog window...

Regards