|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 16th, 2003, 07:27 PM
|
|||
|
|||
|
acces import trouble
I'm having trouble getting MS Access 2000 to import a text file in the manner that I want it. It seems almost impossible to me, but maybe someone will have an idea. The text file that is to be imported is in the following format:
field name: string of information ex: First Name: Jose Last Name: Vega (etc) I can't type it in by hand since there's about a hundred records. All of them are in the same format so that won't be a problem. Is there any way to ommit up to the colon and import the file in that manner. Many thanks. -Jose
|
|
#2
July 18th, 2003, 10:41 AM
|
|||
|
|||
|
a couple of ideas
1. you can write some VB code using mid to pull the part of the string you want 2. if that is not something you are familiar with then open the file in excel or word and use the search find/replace function to delete the colon or otherwise help in reformatting the string
|
|
#3
July 18th, 2003, 07:07 PM
|
|||
|
|||
Yup, I wrote some vb and it took care of of the parsing and rearranging the one column format into the several row format. I guess I should have thought of that huh. Thanks for the help dude.
-Jose
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > acces import trouble |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
