Recent content by xgd

  1. X

    Import String as date

    Okay, I do not know if this is the most elegant way of doing it, but here is how I ended up doing it. Set the field in Access as Date/Time dim FinalName as String then write the field like this:
  2. X

    Import String as date

    Using # as a delimiter: I get runtime 3075, If FinalName is dimmed as String and it imports as 11/30/4752, if FinalName is dimmed as Date
  3. X

    Import String as date

    I have the following code which adds part of the imported filename (filetoimport010420071530.txt) as (01042007) to a field If the field is set to text it imports fine, but is not a date. If the field is set to date it does not import anything. If I dim FinalName as Date it imports as...
  4. X

    Attaching filename to a field while importing

    Should have tried longer brfore posting. I figured it out, here is how I did it. (Although, I am sure there is a better way, I am still in the learning phase) Before: After:
  5. X

    Attaching filename to a field while importing

    Greetings, Excuse me resurrecting such an old post, but I do have a follow-up question. And it was brillant and exactly what I needed. Let's say I have a filename of "city_name010120071530.txt" Using the code in the post, how could I trim "city_name" and "1530.txt" so that the imported field...
See more
Top Bottom