Search results

I am writing code to open many Excel files, retrieve data, and populate Access tables. However, there is always one instance of Excel still running in my "processes" in task manager (doesn't show up in "applications") -- i just can't get it to close. Any help would be greatly appreciated...

I am transfering chunks of data from Excel into Access tables using the transferspreadsheet command. I will be looping through many XL files and creating and/or updating approx. 35 Access tables from each XL. The XL files have a specific order to them. When I transfer the specified range to...

thanks Thank you so much! That works perfectly! I'm not a "programmer" & I would have never tried "nullable"

that does look simple, but I'm not actually using any "TableDef" commands...and all of my tables and fields are variables stored in arrays. Like I said, I am making LOTS of tables. And I need each field in each table to be set to Required = NO. Here is some of my code: Dim tbl As New...

Hi, I am creating (successfully :D ) lots of tables with VBA. I need to be able to set the property called "Required" to False or No. Is there a command to do this? thanks