Forum Discussion
Len_Lane
Jul 03, 2023Copper Contributor
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...
- 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
Jul 03, 2023Bronze Contributor
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.
Len_Lane
Jul 03, 2023Copper Contributor
That is the size of my text field description of the blood image. This is what I defined in my access table.
Thanks for the assistance
Thanks for the assistance
- Len_LaneJul 03, 2023Copper ContributorSeveral Office copies should be available, we downloaded several and cannot find where the were put on the disk drives.
According to Bank of America we paid for them three times. I like the older way of sending them on CD's or flash drives, this download is just too confusing.. I have never heard of eqlite.
Thanks for your concern
Old NASA Kid