Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CLages
Posting Yak Master
116 Posts |
 Posted - 2006-05-31 : 11:18:52
|
| Hi, i have an Aplication in SQL running fine.But my Client has an Another Small aplication from other SoftwareHouse using Access.this small aplication is a Paint(INK) factory system to Creater new colors from the main color(RED, GREEN, BLUE)and has a table in ACESS with all Formulas to do it. Sometimes the factory Update this Formula Table.I would like to know if there are any Options to Import this Tablefrom MDB to MDF Automaticly .tksCLages |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-31 : 11:36:40
|
| Read about DTS or Linked servers in sql server help fileMadhivananFailing to plan is Planning to fail |
 |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-01 : 03:30:56
|
| When you say all formula, do you mean records in table or queries? if records in the table, you can use the Access upsizing wizard or SQL Server DTS. Create link tables in the Access database replacing the original tables (if you still need the Access DB, i.e. if you have Access codes, queries, etc. that use the tables). If you don't need the Access DB or you want to use full SQL Server, change connection objects of your codes to SQL Server, translate the queries to stored procedures/views.May the Almighty God bless us all! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-01 : 04:36:37
|
| This gives you a general idea how to ad-hoc connect to a MS Access databaseSELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Data Source=c:\temp\db1.mdb', 'Table1')See BoL for more information about openrowset. |
|
|
|
CLages
Posting Yak Master
116 Posts |
Posted - 2006-06-01 : 19:37:46
|
| tks for all replyesBut Peso Answers fits best in my caseC. Lages |
|
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-02 : 10:33:07
|
| Sometimes I keep forgetting that the technical jargons can also be a weakness, not just strength. This is one example. When you say "import" or any technical jargon where it exists, it sets the context and drives the solution to that direction. That is why it is important that the business requirement should be stated and not just the "proposed technical solution" being sought. Thanks to people who steps backward and sees cross road and not just the road :). May the Almighty God bless us all! |
|
|
|
|
|
|
|
|
Importing MDB(Table) to SQL(table)