Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Excel data to Access.
I have some data in an Excel spreadhseet which I need to get into Access.
Depending on the data itself depends on where and what needs to be sent. I've built the routine that figures out what needs to be send and where, but I'm at the extent of my knowledge with regards getting the data into Access. I know I'm going to be accused of being archaic however I learnt to use DAO and not ADO, so trying to find help is quite hard to come by. What I need some help on is the connection strings to Access to write or modify the data. I shoud be able to build the SQL myself, but would like to know how to get to the point of ... DoCmd.RunSQL {Some SQL} TIA. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Excel data to Access.
Hi DaveO,
See: http://www.erlandsendata.no/english/...php?t=envbadac --- Regards, Norman "DaveO" wrote in message ... I have some data in an Excel spreadhseet which I need to get into Access. Depending on the data itself depends on where and what needs to be sent. I've built the routine that figures out what needs to be send and where, but I'm at the extent of my knowledge with regards getting the data into Access. I know I'm going to be accused of being archaic however I learnt to use DAO and not ADO, so trying to find help is quite hard to come by. What I need some help on is the connection strings to Access to write or modify the data. I shoud be able to build the SQL myself, but would like to know how to get to the point of ... DoCmd.RunSQL {Some SQL} TIA. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
Sending Data to Access Database | Excel Discussion (Misc queries) | |||
Sending data to Access Database | Excel Discussion (Misc queries) | |||
problem about sending data in Excel to an Access database | Excel Programming | |||
Sending data to Access MDB Table? | Excel Programming |