Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import SGML text file
- Thread starter jw5107
- Start date
Have you tried converting it to a HTML file then importing into Access?
If you dont ask you wont get
Steve Poole
Technical Analyst
Cinram UK ltd
If you dont ask you wont get
Steve Poole
Technical Analyst
Cinram UK ltd
- Thread starter
- #3
jw5107,
SGML? That's old school.
As far as how to convert, if you double click on the file what program opens the document? In that program can you do a Save As? If so you look and see if HTML is an option, how about XML?
If no program opens (like on my computer) you might try importing the file in Access using a file type of XML (XML is a grandchild/subset of SGML).
Hope this helps,
CMP
[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)
SGML? That's old school.
As far as how to convert, if you double click on the file what program opens the document? In that program can you do a Save As? If so you look and see if HTML is an option, how about XML?
If no program opens (like on my computer) you might try importing the file in Access using a file type of XML (XML is a grandchild/subset of SGML).
Hope this helps,
CMP
[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)
- Thread starter
- #5
m33sta & CautionMP,
Awesome..!! I appreciate the suggestions..!!
I'm still having troubles however..
I am exporting an aircraft manual. The export options I have are either ASCII or SGML. Just tryin' to see if I can get it into an Access table or tables... When I open the exported file - I can save it as a HTML file. When I import the HTML file into Access - I get message stating that the file contains no data....???
Any other suggestions...?
jw5107
Awesome..!! I appreciate the suggestions..!!
I'm still having troubles however..
I am exporting an aircraft manual. The export options I have are either ASCII or SGML. Just tryin' to see if I can get it into an Access table or tables... When I open the exported file - I can save it as a HTML file. When I import the HTML file into Access - I get message stating that the file contains no data....???
Any other suggestions...?
jw5107
jw5107,
When you export the file as HTML and view it is the data in a table?
Since it's an aircraft manual I wonder and I'm pretty sure Access will only see HTML data that's in a table.
Without seeing the output I'm thinking other options would be to use a third party parser (like Monarch) or build your own.
CMP
[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)
When you export the file as HTML and view it is the data in a table?
Since it's an aircraft manual I wonder and I'm pretty sure Access will only see HTML data that's in a table.
Without seeing the output I'm thinking other options would be to use a third party parser (like Monarch) or build your own.
CMP
[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)
traingamer
Programmer
Try exporting it as ascii and looking at it with WordPad or Notepad. The SGML option will likely export it with page numbers, etc. Just how big is this manual?
Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
- Status
Similar threads
- Locked
- Question
- Locked
- Question