From WebSite table to MS Access table

I am scraping  a part of text  from webpage table that have one row two column in my  ms_access table.
I have this part of code.
…….....
...................
' Use native VBA file I/O
    tempFile = "D:\tempDate.Html"
    Open tempFile For Output As #1
    Write #1, tableChunk
    Close #1
   

When I open html  “tempDate.html”
Inside that file are value of those two fields:

"
Effective: Oct. 13, 2015 All text in English, small letters.  
"

“Effective: Oct. 13, 2015”---- this part is from first column
“All text in English, small letters. “----- this is from second column.

Problem start now here I have next code to move this in my access temp table

    ' Import the file to a table    
    DoCmd.TransferText acImportHTML, , "tempMyTempDate", tempFile, True

First time it went through and do transfer ,  but create an empty table with two fields.
Titles of those two fields are text value that I would like to have in table fields not in their titles.
First filed title is -  Effective: Oct. 13, 2015”
and second filed title is -  All text in English, small letters.
Next time e.g. on October 14 when I run procedure I got error there is not field with name October 14 2015.

Actually what I need is only date field  I do not need other part or other field:” All text in English, small letters”.
I am using this table  “TempMyTempDate” is just for storing date which I use to append to another table.
TarasAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Snowbella KilangitCommented:
How big is online table, how much data?
What i would normally is copy online into excel, clean the data, then import
0
TarasAuthor Commented:
I told you table is one row two columns and I showed you what is in that table and those two columns. Why you askig me that?
I must be unclear.
0
Snowbella KilangitCommented:
If it is not too much data, then you can probably type information directly into  your Access database. If Its just two rows. Import would make sense if there was a whole heap of data...
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can try creating an Import Spec, and then using that when you call TransferText. To do that, use the wizard to manually import the file, and be sure to use the Advanced button to set the Columns, Datatypes, etc. Just before finishing, make SURE that you SAVE the spec (and remember the name you use when doing so).

Now use that Spec when calling your TransferText method:

DoCmd.TransferText acImportHTML, YOURSPECNAMENERE , "tempMyTempDate", tempFile, True

As long as the file format doesn't change, your spec will be good.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TarasAuthor Commented:
Thanks a lot
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.