473,320 Members | 2,083 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DTS Table Import Issue

I am using DTS to import tables into my new database from another
database, both of which reside on the same server. All the tables,
fields and data copy over fine; however when I go into design view of
the copied tables, the default values for all the fields are lost. It
seems to copy the structure, but not the field properties.

I could manually set the values, but this could prove to be very time
consuming. Thought I may have overlooked a setting or simply missed a
step.

Is it possible to have these properties copied over?

Any help/input would be appreciated.

Oct 28 '05 #1
2 1854
Hi

Using the Copy SQL Server objects task will normally copy defaults. You can
see what options you are using by clicking the options button on the copy
tab.

This sounds like you are using the export/import wizard and the copy tables
option instead of the copy database objects option.

John
"Scott" <sc*************@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I am using DTS to import tables into my new database from another
database, both of which reside on the same server. All the tables,
fields and data copy over fine; however when I go into design view of
the copied tables, the default values for all the fields are lost. It
seems to copy the structure, but not the field properties.

I could manually set the values, but this could prove to be very time
consuming. Thought I may have overlooked a setting or simply missed a
step.

Is it possible to have these properties copied over?

Any help/input would be appreciated.

Oct 29 '05 #2
Yes, I was using copy tables and views within DTS. I have since tested
with copy objects and data and it does copy the table properties over.

Thanks so much!

Scott

Oct 31 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dan | last post by:
Hi all. I have a MyISAM table ( MySQL-4.0.13) that will get truncated every month, and around 1,000,000 records imported into it. The import process consists of a 'load data infile' operation,...
2
by: Bob C. | last post by:
Question: Why would I not be able to import an Access 97 table in which some records have null values in fields that allow null values? Wouldn't the table's design be imported first, bringing...
0
by: me here | last post by:
I have a VBA subroutine that links an MS Excel spreadsheet and copies the data into a local table. This process is controlled by a form that allows users to select the spreadsheet from the file...
6
by: Paul | last post by:
I was wondering if anyone has had an issue where using vba code to read an excel file and import the data into an access table some records are not imported from the excel file. It seems looking at...
3
by: David | last post by:
Hi, We a have a small office network of 3 users. Each user has their own copy of an MS Access Front-End which is linked via their own local ODBC connection to our server's MySQL database (Linux...
6
by: deko | last post by:
Is there a way to set a custom property on Access tables and/or queries to prevent them from being overwritten by import wizards? Any Access database can be easily destroyed if a user mistakenly...
3
by: Odawg | last post by:
Hello All Database (Access) Guru's, I am a novice when it comes to databases and I know enough to get simple information for my needs. With that said, I was given an opportunity for improvement...
5
by: MN | last post by:
Hello, I have a customer table and another table that I need to prepopulate with special customer IDs, unique and not sequential. Is there a way to configure Access to assign the customer ID to...
6
by: Troels Arvin | last post by:
Hello, When doing "DELETE FROM tablename" on a large table, it may take a while if the table is large. On the other hand, the "IMPORT FROM /dev/null OF DEL REPLACE INTO tablename" table runs...
2
by: WP | last post by:
Hello, I've just started to work with DB2 (using the express edition version 9.5 under windows vista) and I'm accessing it through a java program (my java's very rusty). The java program loads the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.