D
Darren
Hello,
I am trying to import excel files into access. I used the code from
(http://support.microsoft.com/default.aspx?kbid=824272) to list the file I
want to import into a list box. Now the tricky part. How do I add two extra
columns of data to this file (based on selections in list boxes) and append
this to an existing table. I am thinking about using a "select into"
statement to append the excel data but am not sure how to add in the extra
two colums. Any help would be greatly apreciated.
I am trying to import excel files into access. I used the code from
(http://support.microsoft.com/default.aspx?kbid=824272) to list the file I
want to import into a list box. Now the tricky part. How do I add two extra
columns of data to this file (based on selections in list boxes) and append
this to an existing table. I am thinking about using a "select into"
statement to append the excel data but am not sure how to add in the extra
two colums. Any help would be greatly apreciated.