Unanswered: ADO Connection with Excel Workbook as datasource
Hopefully you can help me, i am developing a database for where i work. I want to some how read the contents of an Excel workbook and manipulate it via Access Forms. This includes deleting rows and adding new rows.
I have tried using an ADO Connection with excel as the datasource, this works to a point but, the datatype of the tables fields it creates are the wrong type, as i need to store long numeric strings (12 digit) as text but it automatically creates it as adDouble.
I also tried manually creating a table in the front end and parse through the workbook using excel functions, but this was too slow and also led to other problems with excel as the database is to be used in an office environment where excel will be used for other things.
So i am wanting to know if there is any way to connect or retrieve data as a different datatype. Hope this makes sense because i am gradually losing myself.