Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sol1
  • Order by date
  1. sol1

    using Multiple text files (csv) to create one Single table

    Presume this is where I post it ?? Hello Kevin, I would try the following: 1. Do not import the files, but link them to the database (file --> get external data --> link tables, files of type : Text files) 2 Create a union query over the different files through SQL: SELECT * FROM FILE1...
  2. sol1

    using Multiple text files (csv) to create one Single table

    I appreciate your response. This is by first attempt at placing a question on the forum. My specific application is (1) I receive a number of text files with the same fields at a "fixed" width (2) The files will be updated on a monthly basis (3) The previous data is to be...
  3. sol1

    using Multiple text files (csv) to create one Single table

    What is the best solution in MS Access where I have multiple text files (csv) that change on a monthly basis and I wish to place them in one table. I have been advised a UNION query may be best. To date, I have NOT used a Union query All the text files have the same fields Thanks
  4. sol1

    using Multiple text files (csv) to create one tingle table

    What is the best solution in MS Access where I have multiple text files (csv) that change on a monthly basis and I wish to place them in one table. I have been advised a UNION query may be best. To ate, I have NOT used a Union query All the text files have the same fields Thanks

Part and Inventory Search

Back
Top