Search results

  1. A

    Import Text by location

    Based on your response. I have decided to try to undertake the task myself using Excel. I can do it in the Excel. It's just that on the hundreds of times that I run this itwould make a lot more sense to me just to have something that can do it quick and easy in Access since that's where it will...
  2. A

    Import Text by location

    Question is splitting up a text field and importing it into Access 2013 as a date and text field. Bob
  3. A

    Import Text by location

    I have a text file with each line a new record. Each record has 3 fields on each line. They are always in the same location. Example: 022313 534672 13251- More notes. 121913 342231 40251 First value is a date field: "OrgDate" 022313 It should go into a date field called OrgDate as 02/23/2013...
  4. A

    Save accdb files (need to know concept)

    The issue has nothing to do with importing the file. It's all about how to deal with the file once it's imported, such as saving. When I import my Excel file. I would think it should be some sort of a access file. Generally, I have noticed in the past that the file ends up as and accdb. I never...
  5. A

    Convet dBase IV to Access 2013

    Thanks for the help. I only wish I would have thought to use an older version months ago. It is a perfect solution. Bob
  6. A

    import dBase IV to Access 2013

    An older version of Access does sound good. It is just that I found my way with using a dBase utility. Had I thought to use an early version of Access I would have been back to work months ago. I'm not the only one that slipped up on this, so did my Profession Microsoft Access engineries...
  7. A

    Convet dBase IV to Access 2013

    Convet dBase IV to Access 2013 It took about a year with the help of Microsoft's best support. And also dBase Plus 8 http://www.dbase.com/support. You will not be able to load your dBase IV files into Access 2013 without the following. Actually, I should say you will be able to load access...
  8. A

    Save accdb files (need to know concept)

    I am trying to load Excel files into access 2013. I have five different files and they all will be linked. They all will have forums that will be related to the files. There are times when I will want to have the ability to move the files independently. It seems that the main file, accdb, is...
  9. A

    Convet dBase IV to Access 2013

    It took about a year with the help of Microsoft's best support. And also dBase Plus 8 http://www.dbase.com/support. You will not be able to load your dBase IV files into Access 2013 without the following. Actually, I should say you will be able to load access 2013 but as soon as you try to...
  10. A

    import dBase IV to Access 2013

    >>jdraw<< No this did not work. But thanks. Months later and still no cure for Access. Bob
  11. A

    import dBase IV to Access 2013

    This never worked. If you import and than try to change a field size you get a memory error. I spend 20 plus hours with Microsoft with out ever getting a cure for there problem. Or should I say our problem. Yes 20 plus hours with there staff. Bob
  12. A

    Export table

    Left column, All Access Objects, export is what I tried. But it seems to want the file already existing in order to do a export. Bob
  13. A

    split off table

    I have a mean database and would like to remove a couple of tables. I want to keep them, but not in this particular database. You. Want to save them into a different directory also. The tables need to be use with the same database. but not that often. I'm trying to conserve on memory use. If...
  14. A

    many tables with two reference points

    I have broken up by master database, table, into several tables. They all share the same ID values since they came from the master table. So each table that I split off has a unique, matching, identifier, ID, in both the master table and the new table. Plus a previous matching identifier listed...
  15. A

    export from table

    I have quite a few tables in my database. I'm trying to clean up, but can't figure out how to remove tables. The exports wants to export into a number similar file, so it seems. I'm just trying to reduce the size of the database by eliminating some of the tables that I don't use all the time in...
  16. A

    Difference between Numeric and text

    I do understand the concept. Any numbers and text are basically invoice numbers in that type of thing. Any numeric value that will not require a calculation. Bob
  17. A

    Remove layout. Not all was working for me

    Actually you did. My cure for the issue is nothing more than a Band-Aid. Bob
  18. A

    Difference between Numeric and text

    I have a very clear understanding of the issues surrounding text and numeric fields. thanks to all the above. Bob
  19. A

    Table that accepts only certain values

    So if "LimitToList" is set to yes, the values set Row Source to '1;2' would be like a dead issue. it would accept anything. But if I set "LimitToList" to no it will only accept 1 & 2.? Bob
  20. A

    Table that accepts only certain values

    What is "Limit To List to 'Yes'" doing for me. It seems to work either way. Bob
Back
Top Bottom