J
John Spencer
A little more information on what you want to do would be helpful.
If you want to import data into Access from a text file, then the answer is
yes.
If you have a field in a table with the data and it is to be split into
other fields in the same table. The answer is yes, but you must first
define the additional fields in the table and then you must use VBA to split
the data into its components and put the data into the proper fields.
In other words, there is no built-in ability to do this.
You can put the data into Excel, do txt to columns and then bring it back
into Access (again assuming you have the fields defined).
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
If you want to import data into Access from a text file, then the answer is
yes.
If you have a field in a table with the data and it is to be split into
other fields in the same table. The answer is yes, but you must first
define the additional fields in the table and then you must use VBA to split
the data into its components and put the data into the proper fields.
In other words, there is no built-in ability to do this.
You can put the data into Excel, do txt to columns and then bring it back
into Access (again assuming you have the fields defined).
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..