I need help with Upsizing a table

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I used the upsizing wizard to upsize tables in msAccess
xp. everything went well except for one table it would not
upsize. I keep getting the following message on the final
report at the end of upsizing:
**********
Errors
Table:tblName
Table was skipped, or export failed
**********
any Idea why only this particular table? It looks normal
to me like other tables?
thanks
Al
 
It may have been skipped for a number of reasons:

- some field's default value property is set to a function, or something
that the wizard can't find the equivalent.
- the table is hidden

You could always use DTS for this table.
 
What is DTS?
thanks
-----Original Message-----
It may have been skipped for a number of reasons:

- some field's default value property is set to a function, or something
that the wizard can't find the equivalent.
- the table is hidden

You could always use DTS for this table.

--
Joan Wild
Microsoft Access MVP




.
Click to expand...
 
Data Transformation Service - It's in SQL Server and you use it to import,
rather than upsize from Access.

(you are talking about upsizing from Access to SQL Server, right?)
 
Yes and No. I am upsizing to MSDE which is "sql server". I
am going from .mdb to .adp. I am not sure if this feature
DTS can be used there?
Al
 
Hi Joan,
after I sent you a reply, I tried the get external data--
Import from within the ADP file. I got the following error
message:
ODBC--Call failed
[Microsoft][ODBC SQL Server Driver][SQL Server] Error
converting data type varchar to datetime.(.(#8114).

Now this calls my attention to a field in the .mdb db that
is called "unknowdate", this field is a text field but the
data in it written in the following format:(y/y/1980 or
2/y/1999,etc...) could this be the reason. may be MSDE
viewing it as real date and trying to make the conversion
from text (varchar) to date?
Al
 
Hi Al,

No MSDE does not include any tools like DTS.

I can't see why MSDE would think it's a date. I don't know what to suggest.

Perhaps you should ask in
microsoft.public.access.adp.sqlserver

--
Joan Wild
Microsoft Access MVP

Al said:
Hi Joan,
after I sent you a reply, I tried the get external data--
Import from within the ADP file. I got the following error
message:
ODBC--Call failed
[Microsoft][ODBC SQL Server Driver][SQL Server] Error
converting data type varchar to datetime.(.(#8114).

Now this calls my attention to a field in the .mdb db that
is called "unknowdate", this field is a text field but the
data in it written in the following format:(y/y/1980 or
2/y/1999,etc...) could this be the reason. may be MSDE
viewing it as real date and trying to make the conversion
from text (varchar) to date?
Al
-----Original Message-----
Data Transformation Service - It's in SQL Server and you use it to import,
rather than upsize from Access.

(you are talking about upsizing from Access to SQL Server, right?)

--
Joan Wild
Microsoft Access MVP




.
Click to expand...
Click to expand...
 
Hi Al,

I upsized a database to SQL Server and the tables that it would not upsize,
it turned out, all had one or more field names that were legal in Access but
were reserved words in SQL Server, e.g. "Left", "Right", etc. I had to
manually create the tables in SQL Server, using the bracket operator []
around the field names that were using reserved words, e.g.
,
.

I can't see why SQL server would not be able to convert values as you
describe from varchar to datetime. The datetime data type in SQL server is
actually a double-precision floating-point number. But you can INSERT data
into SQL server as 'm/d/yyyy' or several other variations of that, using
single quotes around the textual representation. Acess, however, usually
surrounds such textual representations with #m/d/yyyy#, which is *not* legal
in T-SQL.

There is a microsoft.public.sqlserver.msde newsgroup which you can try,
also.

Regards,

Ron

Joan Wild said:
Hi Al,

No MSDE does not include any tools like DTS.

I can't see why MSDE would think it's a date. I don't know what to suggest.

Perhaps you should ask in
microsoft.public.access.adp.sqlserver

--
Joan Wild
Microsoft Access MVP

Al said:
Hi Joan,
after I sent you a reply, I tried the get external data--
Import from within the ADP file. I got the following error
message:
ODBC--Call failed
[Microsoft][ODBC SQL Server Driver][SQL Server] Error
converting data type varchar to datetime.(.(#8114).

Now this calls my attention to a field in the .mdb db that
is called "unknowdate", this field is a text field but the
data in it written in the following format:(y/y/1980 or
2/y/1999,etc...) could this be the reason. may be MSDE
viewing it as real date and trying to make the conversion
from text (varchar) to date?
Al
-----Original Message-----
Data Transformation Service - It's in SQL Server and you use it to import,
rather than upsize from Access.

(you are talking about upsizing from Access to SQL Server, right?)

--
Joan Wild
Microsoft Access MVP

What is DTS?
thanks
-----Original Message-----
It may have been skipped for a number of reasons:

- some field's default value property is set to a
function, or something
that the wizard can't find the equivalent.
- the table is hidden

You could always use DTS for this table.

--
Joan Wild
Microsoft Access MVP

message
I used the upsizing wizard to upsize tables in msAccess
xp. everything went well except for one table it would
not
upsize. I keep getting the following message on the
final
report at the end of upsizing:
**********
Errors
Table:tblName
Table was skipped, or export failed
**********
any Idea why only this particular table? It looks normal
to me like other tables?
thanks
Al



.



.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top