473,378 Members | 1,417 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,378 software developers and data experts.

how to export table from access database to a new access database

i have a table tablessales on a database1.mdb. now i want to export the said table to newdatabase.mdb

how to code this pls

thank you
Oct 1 '10 #1
1 1269
debasisdas
8,127 Expert 4TB
Why you need to code that .
Simply use the inbuilt functionality of access for the purpose.
Oct 4 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Galina | last post by:
Hello I already initiated a thread with the same name on 22/03/2004. Thank you everyone who answered me. I wanted to link to that thread, but somehow there was no "Post follow on article"...
2
by: cant_belto | last post by:
Hi guys I have this mini project that I could surely use some advice with. Any assitance will be appreciated Quick summary: Need to export one table created in Access 2k in a new database...
2
by: greg w | last post by:
I can't seem to find the syntax to export data from a given .mdb to another. I can only find the opint-and-click way, which is not what I want. Any suggestions? Thanks, Greg
2
by: Piotr | last post by:
Hi, I have set up, table export to mysql database and works weel bout I have problem with polish fonts ? Is tehere any way to change coding on the fly ? regards Peter
1
by: learning_codes | last post by:
Hi , I'm wondering if there is a way for me to export some tables including data and structure from old database to a new database and then save as new database name. I try to create a marco...
17
by: IC1(SW/AW) | last post by:
I am trying to create a unique type of registration form for my job upcoming Holiday Christmas Party. There will be 60 tables for seatings with 10 people max at table. How can I write some...
2
by: =?Utf-8?B?YmJkb2J1ZGR5?= | last post by:
Hi, How do I export data from an Access query or table to a csv file? Thanks in advance
9
by: NEWSGROUPS | last post by:
I have data in a table in an Access 2000 database that needs to be exported to a formatted text file. For instance, the first field is an account number that is formatted in the table as text and...
0
by: Hemant Pathak | last post by:
Hi All i m working in Vb 6.0 and Access 2000 i want to export Table or Query Source database to Destination Database
16
mikek12004
by: mikek12004 | last post by:
How to copy a table (with the data) from one server to another (the two servers are in different PCs)? Basically if I could move the data to a txt file inthe form of the insert command (like the...
1
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: 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...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.