By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Import / Export From Access

P: 10
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
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
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

P: 10
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
Expert 100+
P: 254
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

Post your reply

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