Thread: Multiple Spreadsheet Importing in microsoft.public.access.externaldata

  Sadly I have no control or say over how the spreadsheet portion works. That's a completely different ball of wax. But the spreadsheet with "09306_09311" isn't for September of 2006 -- it's for the week starting on 11/02/09 and ending on 11/06/09 -- I believe it has to do with a Julian Date (but that's just a guess, I've never seen these spreadsheets before). As for a week that crosses a...

  Take a look at Ken Snell's page here: http://www.accessmvp.com/KDSnell/EXCEL_Import.htm -- --Roger Carlson MS Access MVP www.rogersaccesslibrary.com http://rogersaccessblog.blogspot.com/ "MugWump via AccessMonster.com" <u36273@uwe> wrote in message news:9eec1c241c5b2@uwe... > Hiya Folks > > So here's the deal: > > I've been asked to create a database...

  There are a couple of design issues that make it more difficult than it needs to be. First, you don't use a consistent string that indicates the dates. For example, 09306 may be easy to interpret it as June 30, 2009, but how about 09311? Is it January 31, 2009 or is it March 30, 2009. So you need to change the format to be six characters as yymmdd. That will make it easier to parse out. And which folder does the sheet go in...