Hi,
i have a table with dates on x axis and name along the top. The table is either populated with values or #N/A. For the #N/A cells Im going to have to write a code in access to retireve additional values, however as the table is quite large, 10000+ records, what I wanted to know was could this be written by a macro in excel and exported to a text file so that I can copy into access..
I have most parts of the access code written but just need it to be changed for each #N/A instance the date and name used in code. The three generic parts are located in Sheet 2 (calls A1,A2 and A3) so that the excel formula is =CONCATENATE(A1;Name;A2;Date;A3) and then would move onto the next #N/A instance.
Hope that made sense
i have a table with dates on x axis and name along the top. The table is either populated with values or #N/A. For the #N/A cells Im going to have to write a code in access to retireve additional values, however as the table is quite large, 10000+ records, what I wanted to know was could this be written by a macro in excel and exported to a text file so that I can copy into access..
I have most parts of the access code written but just need it to be changed for each #N/A instance the date and name used in code. The three generic parts are located in Sheet 2 (calls A1,A2 and A3) so that the excel formula is =CONCATENATE(A1;Name;A2;Date;A3) and then would move onto the next #N/A instance.
Hope that made sense