Recent content by jfrink2

Hi All, I have a macro set up using the TransferSpreadsheet action to import an excel spreadsheet into an access db. I now have a new requirement to password protect this spreadsheet. When I try to import the spreadsheet with password protection activated, I receive the following error msg...

After making this change, I still get the same error message. Any other ideas?

Hi All, I have a report that calculates variances. For example, there are 2 columns on my report. One has # of Hours from one system and the other column shows # of Hours from a second system. I then have a column that displays any variance that may occur. When there is a variance, the report...

Null in this case represents an empty value.

Would that be after the file has been imported to the tables? Or would you have the query make this adjustment to the file during the import process?

Hi All, I have a table that has fields that captures dollar amounts. I have these fields set to a default value of "0". The tables are updated via a query that imports a csv file. Once the import process has finished, my table has blank values in some of the fields that capture dollar...