Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Importing all data as text for Microsoft Access

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 2 posts
Is there a setting or property in Microsoft Access I can set so that all imported columns are always text? I spend most of my day importing large text files in to Access databases and many columns are catalog numbers where I want to keep the leading zeroes or Access only looks at the first couple entries and determines they are numbers but further down they start using alpha-numeric numbers resulting in import errors. Its such a waste of time for every table have to scroll through the advanced options and change every column from number to text after an import, sometimes having to change over 50 columns.

This is for Microsoft Access 2000.
  • 0





  • Member
  • PipPip
  • 98 posts
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
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
  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP