This is for Microsoft Access 2000.
Importing all data as text for Microsoft Access
Started by
PJYelton
, May 17 2005 12:08 PM
#1
Posted 17 May 2005 - 12:08 PM
This is for Microsoft Access 2000.
#2
Posted 04 June 2005 - 02:13 AM
I had simialr problems in the past and overcome them by the following method. You may need to save your data in a CSV format.
in Access
File > Get External Data > Import
select your file eg. *.csv
import
advanced --- at this point you can create an "import specification" this is the key to your solution.
"save as" will allow you to save the import specification for future use.
Hope this helps
in Access
File > Get External Data > Import
select your file eg. *.csv
import
advanced --- at this point you can create an "import specification" this is the key to your solution.
"save as" will allow you to save the import specification for future use.
Hope this helps
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users