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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2007-02-13 : 06:36:49
|
| I have a SQL table where most of the fields are numeric. I have tried to run a query in Access to either make a new Access table or insert the records into an empty Access table. However, it changes some of the numeric fields to text fields. Also if I view the design of the SQL table in Access some of the numeric fields appear as text. If I view it in SQL they are numeric. It is a linked table in the Access database. |
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2007-02-14 : 08:59:02
|
| Used a pass through query |
 |
|
|
|
|
|
Problems using SQL table in Access RESOLVED