Forum Discussion

Len_Lane's avatar
Len_Lane
Copper Contributor
Jul 03, 2023
Solved

Creating an Access Table from an Excel Worksheet with only one 55 character Column

I have been trying for days to take the names of Blood Samples, between 7,700 and 7,900 records and put them into an access table.  The Worksheet has only one column, which is the name of the lab tes...
excel
  • peiyezhu's avatar
    peiyezhu
    Jul 08, 2023

    When I moved all of the programs over, they all bombed.

    Vba program? how did you move it?

    copy the only one .accdb file to flash disk and paste to your Win11 from the flash disk .

    Or send email attachment.

    You have a VBA program already？

peiyezhu's avatar
peiyezhu
Bronze Contributor
Jul 03, 2023

just cannot get the one column worksheet into the access table
If possible,upload your .xlsx file for test.

I am confued about below:
but the name of the image never exceeds 55 characters.
peiyezhu's avatar
peiyezhu
Bronze Contributor
Jul 03, 2023
if access not available,why.not sqlite?
  • Len_Lane's avatar
    Len_Lane
    Copper Contributor
    Jul 03, 2023
    Peiyexhu;

    I am not familiar with sqlite at all, If you can tell me more about it.
      • Len_Lane's avatar
        Len_Lane
        Copper Contributor
        Jul 05, 2023

        peiyezhu 

         

        I finally have a perfect Table with all of the names of the images.

        It is a lot quicker working with the Access Community.

         

        After speaking to the IT guys from Amsterdam on the phone a few minutes ago, they seem to be the most knowledgeable pathologists, I had to tell them we will go no earlier than Access 2010.

         

        I know that the hospitals in the very rural areas have serious financial situations and that ransomware has taken a serious toll on them. However the problems that arise from rare instances, usually come from very rural areas in Africa and South America.

         

        I am going to stick to Access 2016, do everything there and move that to the later updates.

        The IT pathologists in Amsterdam feel the best image is 4821 in Horizontal pixels and 3456 in vertical pixels.

         

        I have no idea of what I am going to run into and there could possibly be some deviations. That will be the decision of our four top hospitals in the U.S.

         

        I am still not clear about the name of the medical slides and the images from the microscopic pictures being in different areas.

         

        From what I can tell I am going to have to use an SQL query to work with the images to create a perfect image.

         

        I got some ideas from the guys, but cannot seem to come up with the appropriate syntax and this has been my major problem all along.

         

        Since the image is not in the table, just the name of the image, where is the image itself?

        I have the smallest blood category which is only 33 of the about 7,500 that I am going to do my tests of.

         

        Sometimes being new to Access, I feel like an idiot and sometimes confused. This reminds me of the old RPG that Burroughs came out with 40 years ago somewhat, a lot of confusing rules.

         

        I need the format of the Instruction of the image to try to mess with, I may have to come up with a math formula.

         

        You guys have been great and have more patience that I do, but I do have a lot of people breathing down my back.

         

        FYI, Hospital research is no longer permitted to use Facebook by law.  I am also going to check out the open source program you recommended.

         

         

        Old NASA Kid

Resources