DB Gurus, Is there any way to take the excel fields and create a form that captures all the data to a DB that we can pull reports from?
user01 · Feb 12, 2015 4:02 PM · 258 views
What i usually do is.. I did that in vb.net architecture.. you can find solutions how to extract spreadsheet to grid, then grid to database would not be a problem.. you can easily look for it..
guitarcenter · Feb 12, 2015 4:18 PM
Can you accomplish this from excel to Access?
user01 · Feb 12, 2015 4:24 PM
I have done it excel to SQL but not access. I believe it would be the same way.. but different syntax.. Depends on which platform you are using.. I did it in vb.net.. if you are using different platform then way of doing it will be different..
guitarcenter · Feb 12, 2015 5:52 PM
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion