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 08, 2023
if possible,upload and share you .accdb or .mdb file.
Also, please screenshot what happened on your side.
peiyezhu's avatar
peiyezhu
Bronze Contributor
Jul 08, 2023
Is the name of your .accdb file database.accdb (you created the file from desktop shortcut?).

If so,rename database.accdb to myImgDb.accdb and try again.
  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    Jul 08, 2023
    if you are familar with c language and Assembler language，why not try other development tools instead of VBA.

Resources