Solved

Check the compatibility of data type of append query!

Posted on 2008-10-20
2
376 Views
Last Modified: 2013-11-28
i have append query where some data is filled to another table. But in the table which is filling the data is shown as query name (not table name)
 
 i need to check the compatibility of data types.. how i can check this?
 
 
0
Comment
Question by:jaisonshereen
  • 2
2 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 22759286
The query will inherit the data types of the table.columns that it is reporting on.
To 'check the compatibility', manually determine the data type of the source, and compare it to the destination.

It's generally not a good idea to be dependant on some kind of automated compatibility.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 22760671
Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question