Need help with a Microsoft Access append operation generating an invalid argument error.

Question

Included is a screenshot of my DB in design mode as well as a screenshot of my Google Sheets CSV. When I attempt to append the CSV I get an invalid argument file and I cannot figure out why. Any help would be greatly appreciated.

Answer 1

I would recommend a couple options.

1. Try create a linked table to the CSV file and then append it to your production table
2. Import into a table of all short and long text. Then use an append query to the production table.

Answer 2

Please note that Q&A forum is a public platform, and moderators will modify the question to hide personal information in the description. Kindly ensure that you hide any personal or organizational information the next time you post an error or other details to protect personal data.

Hello Chad Deihl

When I recreated the data based on the screenshot you provided and tested it on my side, I noticed a few things:

1. The Hyperlink data type should be temporarily changed to Short Text.
2. When I recreated the file in Google Sheets and downloaded it as a CSV, the dollar sign ($) was still present. Since these fields are formatted as Currency in Access, you can simply change them to Number format in Excel.
3. For cells that contain $0, it’s better to either leave them blank or replace them with just 0.
4. For calculated fields, if they contain formulas, it’s best to review them and leave them blank for now (I left them blank on my side during testing).

Hope this information helps. Please try making these adjustments and check if the import works.

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.