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 |
|
ssweeney
Starting Member
3 Posts |
 Posted - 2007-08-14 : 11:14:26
|
| I am importing tables from an AS400 (cims) program for our school and i can see all of the tables in the database except for the alias ones. I had to create an alias to use a specified member in that database. There are many different school districts so i had to use ION__00 as a member to see the data from my school. I can point to the table psch100 but no data is there because i couldnt name a member. If needed i can run the program through access and then import from there. Problem is i want this do be done on a daily basis.Suggestions?Shawn |
|
|
|
|
|
importing data using alias tables from AS400