Import / Export From Access - Microsoft Access / VBA

Hi guys,

Wonder if you can help me at all been searchng the web to see how to export a database and then import it. I am not bothered about the format (*.csv) or (*.txt).

If any one could help or point me in the right direction it would be appreciaited. Cheers,

T

Dec 31 '07 #1

Subscribe Post Reply

1248

missinglinq

3,532

Expert 2GB

What kind of database? Export from where? Import into where? I'm sorry, but your post simply doesn't begin to give anyone enough information to help you! And you certainly should be "bothered by the format!" It can make a world of difference!

Welcome to TheScripts!

Linq ;0)>

Dec 31 '07 #2

tmh86

Currently using the standard sql database within access. I want to be able to export this preferably to excel to put back into later versions of my programme.

I am a new comer to this so any light you could shed on the advans of the different formats would be apprieciated.

T

Dec 31 '07 #3

jaxjagfan

254

Expert 100+

Currently using the standard sql database within access. I want to be able to export this preferably to excel to put back into later versions of my programme.

I am a new comer to this so any light you could shed on the advans of the different formats would be apprieciated.

T

Do you have multiple users using different versions of MS Access (you mentioned later versions of program)?
If moving data to and from export files it is better to use delimited files (.txt or .csv) over excel (.xls). Excel will sometimes changes your data types based on the first row of the data it receives - if the first row of a column has all numerics but the column is alpha - excel assumes column is numeric.

You would need to look at TransferText and setting up Import and Export Specifications.

DoCmd.TransferText
acImportDelim, "ImportSpecName", "ImportTableName", "PathandFileName"

Dec 31 '07 #4

Similar topics

Import PARADOX Problems

by: TonyMontana | last post by:

Hello, I've the following problem. I've to read out the data of a custom application. I think (I'm not sure) this application is using a Paradox DB to store it's information. I don't know it...

Microsoft SQL Server

export (from mdb)-> import (to MS Sql server)

by: BUSHII | last post by:

I have big problem. In database MyDB.mdb I have table for example: ORDERS with colums: - Id int - Name varchar(20) Also I create same table in SQL Server 2k. I can manualy export this data...

Microsoft SQL Server

Export and Import certificates with private keys

by: Ivan Zuzak | last post by:

Hello. Sorry for crossposting, but i didn't have a better idea as to where to post the question. I'm using certificates to sign and encrypt SOAP messages, using WSE in .Net. I want to do the...

.NET Framework

Export to csv having issue with import to SQL(Remedy)

by: N. Graves | last post by:

Thanks for taking the time to read this note. I have a Access inventory collection tool that I have automated to build and Export to a CSV file. In the database I have several fields that are...

Microsoft Access / VBA

Can you import/export using MySQL Administrator?

by: phillip.s.powell | last post by:

We're looking at a GUI interface for our MySQL DB and I am interested in MySQL Administrator, however, one of our requirements is to be able to import/export databases. Is this possible or do I...

MySQL Database

Import Excel data with .NET

by: Niklas | last post by:

Hi Before I start coding I need to be sure that nobody else has not done it yet and that I can use it. I need an import utility which import data from Excel to a database or some object in...

C# / C Sharp

Access 97 import and export of text and HTML not working

by: Wandering | last post by:

I know you guys are heavy duty coders, while I do ad-hoc analysis, and rarely write code. And, I may be in the wrong groups because this is about an install issue, and I don't think it's a code...

Microsoft Access / VBA

Prevent Import Table Period.

by: perryche | last post by:

Is there a way with MS Access 2002 and above to prevent people importing from a blank Database the tables in another database? I have done a lot of searches but there isn't really a solution that...

Microsoft Access / VBA

Export to Excel, update by other User and Import back to Access

by: Pauline | last post by:

Dear all, I have an enormous database (Access 2003) containing sales information, and an Excel tool to enable end users to do planning and forecasting. Untill now I would create several queries,...

Microsoft Access / VBA

The best file format to import/export data into sql database through asp.net application

by: Max2006 | last post by:

Hi, We are developing a SQL server based asp.net application. As part of requirement we should allow users import/export some relational data through web user interface. We are investigation...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

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,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

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$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server