Ga$Analy$t
New Member
- Joined
- Nov 28, 2006
- Messages
- 24
Hi all, if anyone can offer any advice or hints on how best to tackle this issue, i'd be eternally greatful!
I've had a good trawl through the forums and can't seem to find any solutions to this issue...
I have a text file that contains data tables that I want to import into an Access database. The only issue is there is multiple tables in the one file.
My text file looks like this
Results for "FILENAME"
Table1
Name State Power Flow
ABER ON 30 50
ALRE OFF 40 10
etc
.
.
.
Table 2
Name Tag Eff(%) Pres Speed Temp
AAAA RNE 100 55.1 5000 3.5
etc
.
.
.
(there are multiple spaces between each column and the columns are all lined up perfectly)
If there was just one table per text file, then there would be no problem importing the data, but as the tables are all of different widths with different amounts of columns, any of Access import options screws up all the tables...
I was thinking about maybe searching the text file for "Table 1", then "Table 2" and somehow separating the tables first so that they can be imported as separate tables.
Does anyone know of a solution for this type of problem??
I can elaborate further or upload my text file somewhere if it will help..
Thanks in advance!
I've had a good trawl through the forums and can't seem to find any solutions to this issue...
I have a text file that contains data tables that I want to import into an Access database. The only issue is there is multiple tables in the one file.
My text file looks like this
Results for "FILENAME"
Table1
Name State Power Flow
ABER ON 30 50
ALRE OFF 40 10
etc
.
.
.
Table 2
Name Tag Eff(%) Pres Speed Temp
AAAA RNE 100 55.1 5000 3.5
etc
.
.
.
(there are multiple spaces between each column and the columns are all lined up perfectly)
If there was just one table per text file, then there would be no problem importing the data, but as the tables are all of different widths with different amounts of columns, any of Access import options screws up all the tables...
I was thinking about maybe searching the text file for "Table 1", then "Table 2" and somehow separating the tables first so that they can be imported as separate tables.
Does anyone know of a solution for this type of problem??
I can elaborate further or upload my text file somewhere if it will help..
Thanks in advance!