I havedownload the MS free sql edtion but dont have any coding experience using sql, just access a few years ago using sql.
I have built an excel spreadsheet on vb code, and would like to push the totals into a sql server table and the pull them across a netowrk into another pc.
The totals are calculated every 1.5 seconds in the excel vb code.
Can anyone supply me with the code to push excel to sql, then sql to excel.
I guess the sql code will need to push the data to excel on a time bases maybe 1 sec.
Many thank for reading this