hello there experts!!!!
i have a table in ms access with data in it. it is called "customers".
it had fields like customerid,customer name,customer surname e.t.c
i want to import this table in an sql server 2005 database called "mydatabase".
in MS access in the design view of the customer table next to each field and data type i have entered details for the description of each field. e.g customername-Text- a field tha holds the customer name.
can you please show me how to import the customers table in the "mydatabase" sql server 2005 database? and most importantly i need to import the ms access table with its data and i want the description of each field to be imported as well.