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 08, 2023Bronze Contributor
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?
Len_Lane
Jul 08, 2023Copper Contributor
To get my VBA to work, I need to use a Command Button to fire it.
I am having some security issues because I cannot enter the query to try to test the VBA.
The State of Nebraska sent us a small test database, but I am too hung up on getting there to try it.
I do have an Assess Table with what I need to continue on, once I can get to a point where I can test the queries.
Thanks Again
I am having some security issues because I cannot enter the query to try to test the VBA.
The State of Nebraska sent us a small test database, but I am too hung up on getting there to try it.
I do have an Assess Table with what I need to continue on, once I can get to a point where I can test the queries.
Thanks Again