Forum Discussion
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...
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？
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.
I brought the programs over from a 2010 office to my friends Office 365 and all of the programs bombed.
On the Dim dbp as DAO.Database, I get a
User-defined Type Not Defined,
I must have missed something,
What did I goof up on now.
Thanks Again
Old NASA Kid
On the Dim dbp as DAO.Database, I get a
User-defined Type Not Defined,
I must have missed something,
What did I goof up on now.
Thanks Again
Old NASA Kid
- if possible,upload and share you .accdb or .mdb file.
Also, please screenshot what happened on your side.