Need Code to Automate ImportExportSpreadsheets (1 Viewer)

ace2014

New member
Local time
Today, 10:32
Joined
Jun 3, 2014
Messages
1
Hello Everyone,

I'm super new to VBA and Access automation tools. I've done more of database planning, theory, creation, and reporting.

This is my first time in an open source forum!!

Anyhow, any help would be super appreciated.

Objective:
Automate ImportExportSpreadsheets
Vision: button that when clicks prompts user to enter Excel file path, file name, and adds "/" and ".xlsx"
This table will be a template and the users will paste the information they'd like to append into a specific datatable in Access.
I can have the Excel table match the destination table, but there are 2 columns that would be more clear for the users if their titles differed.
The users don't need to know which table they're appending to, just that their information has being added.

The macro should append the Excel Sheet to the table I've defined. I'd then want the excel table the user appended to not be in the database, it would be even cooler if Access could go ahead and clear the table in Excel after as well the data has been appended.

Attempts:
I've tried looking for code, but I just don't understand it well enough since the variables are usually tailored to specific cases.
My original goal was to use the Macro ImportExportSpreadSheet and to transfer it to VBA code, but that doesn't seem to be working.
I also continuously get an error telling me that F1 is not found in my destination table in Access. I've also researched various solutions and nothing has seemed to be working.
I've double check the columns, formatting, names of all paths, files, extensions, I tried the .csv file, etc.
I did eventually get the F1 to go away for a little while, but when I tried to transfer it to VBA, it told me it was successful, but the code just pointed to a failed attempt.

This is a process I'll need to repeat with 5 other tables, so it's really important. After struggling, all that comes to my head is, it's not that hard without the automation, they can figure it out haha.
Anyways, thanks in advance for any help you guys can give me :)
 

Users who are viewing this thread

Top Bottom