Import help

[Bobbie]

I need to import an excel file every week into Access. The file is always saved in the same folder called "Current" however the file name changes week to week because of a date and time stamp.

For example this week the file is named: Weekly_Internet_Order_Matchup_Converted_Channel_Su mmary_20120721_080603
next week it will be
Weekly_Internet_Order_Matchup_Converted_Channel_Su mmary_20120728_074452

Is there a way for me to import the file by ignoring everything after the "y"?

 

[pr2-eugin]

Someone who is well experienced in this area will surely come to help you.. This forum is full of people who spend their own time to help others. So a kind advice.. Please do not double post..

http://www.access-programmers.co.uk/forums/showthread.php?t=230550

 

[Bobbie]

Sorry, New to this and I posted it under modules but noticed there weren't as many people in that forum as general so i wanted to post it where I might get a faster response. I have already spent a couple of hours trying to figure this out and am getting increasingly frustrated.