Import / Export From Access

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

re: Import / Export From Access

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

re: Import / Export From Access

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

re: Import / Export From Access

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"