Click here to Skip to main content
15,671,597 members
Search within:


How Do I Copy an MS Access Database Table?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
VB
I am using Visual Studio 2013 and VB.Net. I am looking for sample VB.Net code to copy an Access database Table (structure only - no data) into the same database but with a new name for the Table. I have not been able to find an example of the proper VB.Net code to accomplish this. Thank you in advance for any help you may be able to offer.
Posted
Add a Solution

1 solution

Will a SELECT INTO statement work? I know it does with SQL server.
For example SELECT * INTO newtable FROM oldtable WHERE 0=1
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Copying MS access table in C#?
Copy MS SQL database tables to MySQL database
How to copy access database tables to another access database in C#
Copy CSV records into MS Access table
copy data from array to table in ms access
Combobox in VB.NET with MS ACCESS database v
How to increase the table size in MS access database
Need help in how to copy a table in MS SQL Server using VBA in MS Access
How to copy data from online SQL server table to local access database table?
Copy tables from one database to another on C#

Advertise
Privacy
Cookies
Terms of Use
Last Updated 25 Apr 2015
Layout: fixed | fluid
Copyright © CodeProject, 1999-2023
All Rights Reserved.

Web01 2.8:2023-05-13:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900