January 23, 2012 at 7:50 am
Hi,
I am new to MS Access (2007) and have a requirement to add an existing table to MS- Access database. There are 4 tables already associated with the database and I wish to add another one to it. Does someone know how to go about it ?
Thanks,
Paul
January 23, 2012 at 8:16 am
Click "Create" on the top menu bar/ribbon....select "Table"
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 23, 2012 at 8:17 am
pwalter83 (1/23/2012)
Hi,I am new to MS Access (2007) and have a requirement to add an existing table to MS- Access database. There are 4 tables already associated with the database and I wish to add another one to it. Does someone know how to go about it ?
Thanks,
Paul
You say you have to add an existing table to Access? Where does it exist? Can you just reference it externally (link table)? Or do you just need to add a new table? If the latter then just follow the instructions already posted.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 23, 2012 at 8:18 am
J Livingston SQL (1/23/2012)
Click "Create" on the top menu bar/ribbon....select "Table"
Thanks for your reply, however, I do not want to create a new table from scratch. I only wish to import an existing table and add it to the list of tables already there.
January 23, 2012 at 8:21 am
Sean Lange (1/23/2012)
pwalter83 (1/23/2012)
Hi,I am new to MS Access (2007) and have a requirement to add an existing table to MS- Access database. There are 4 tables already associated with the database and I wish to add another one to it. Does someone know how to go about it ?
Thanks,
Paul
You say you have to add an existing table to Access? Where does it exist? Can you just reference it externally (link table)? Or do you just need to add a new table? If the latter then just follow the instructions already posted.
The table exists in SQL Server as are the ones that are already added. I do not wish to create a new table, just add an existing table to the list of tables already there in the left pane under 'All tables'.
January 23, 2012 at 8:25 am
Ok so do you need to have the table in Access detached from SQL server or can you create a link table via ODBC?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 23, 2012 at 8:26 am
pwalter83 (1/23/2012)
J Livingston SQL (1/23/2012)
Click "Create" on the top menu bar/ribbon....select "Table"Thanks for your reply, however, I do not want to create a new table from scratch. I only wish to import an existing table and add it to the list of tables already there.
Apologies...misread your requirement.
External Data > More > ODBC Database
you can link or import from SQL
you will need a DSN to connect.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 23, 2012 at 8:45 am
J Livingston SQL (1/23/2012)
pwalter83 (1/23/2012)
J Livingston SQL (1/23/2012)
Click "Create" on the top menu bar/ribbon....select "Table"Thanks for your reply, however, I do not want to create a new table from scratch. I only wish to import an existing table and add it to the list of tables already there.
Apologies...misread your requirement.
External Data > More > ODBC Database
you can link or import from SQL
you will need a DSN to connect.
Thans for your help, it worked !
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply