I get a csv file from a provider that won't import correctly into an access table. Two of the columns contain a 10 digit phone number. When I try to import the file these two columns don't import. I have written an excel macro to add single quote marks to each side of the phone number making the column text. Now when I import it all works correctly.
In my process I edit the csv file in excel and save the copy to the same name each month. This name is "ipwork.csv". I have an excel macro that will take care of the file editing to add the single quotes.
How can I add the language to my access Form VBA attached to an access form button to take care of running this excel macro, saving the excel file as the same name (ipwork.csv). I can then import the file to an access table.
Thanks in advance for any help you can provide.
Ron
In my process I edit the csv file in excel and save the copy to the same name each month. This name is "ipwork.csv". I have an excel macro that will take care of the file editing to add the single quotes.
How can I add the language to my access Form VBA attached to an access form button to take care of running this excel macro, saving the excel file as the same name (ipwork.csv). I can then import the file to an access table.
Thanks in advance for any help you can provide.
Ron