|
Yes it will, you just need to click your mouse to the left of the item you want to download. If it still does not work, then you need to complain to Microsoft.
|
|
|
|
|
To be fair, I tried that link myself, and it failed for me, presumably in the same way as for the OP. (I was wondering how it could be so hard.)
Turns out there is a hidden check box or button just to the left of the files.
|
|
|
|
|
Yes it took me a while to figure out the how to do it. But it is Microsoft of course.
|
|
|
|
|
by clicking on the link that u provided m taking to the download page and when i click on download then it takes me to file selection option but m not able to slelec any file there
|
|
|
|
|
I just tried it. It didn't seem to work for me either.
It is a really weird screen.
If you click just to the left of the two files listed a 'box' will appear. It is just white space until you click on it. The box will disappear once your mouse moves away. However once selected the text box to the right will say that you have selected a file (or two) and the 'Next' button at the bottom of the screen will be highlighted.
|
|
|
|
|
It must be your browser. The checkboxes appear and work fine for me in Firefox 54.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I tried this (and another similar Microsoft page) in both Chrome and Edge, and the checkboxes did not show up in either.
|
|
|
|
|
That's very odd. The checkboxes show up fine for me in Firefox, Chrome (v59), Chrome Canary (v61), Edge (v40.15063.0.0), IE11 (v11.413.15063.0), and Opera (v46).
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Even odder, they now show up for me on both the pages I was trying the other day. I suspect a recent web update.
|
|
|
|
|
They now show up for me also.
|
|
|
|
|
Richard Deeming wrote: The checkboxes appear and work fine for me in Firefox 54
Mine is Firefox 54.0.1
Something odd I just noted however - it says 32 bit. My box is 64 bit.
|
|
|
|
|
AFAIK, the default download for Firefox is 32-bit, even if you're on a 64-bit OS. You have to click on the "Firefox for Other Platforms & Languages" button to get the 64-bit version.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I've been trying to do this for while and haven't made any progress.
I have a tab-delimited file with records for a database file. One of the fields has a local file link for a text file. Each record points to a different text file and there are 151,806 rows, so replacing the file names ("C:\files\LAW_SECTION_TBL_1.lob", "C:\files\LAW_SECTION_TBL_2.lob", ..., "C:\files\LAW_SECTION_TBL_151806.lob") one-by-one with the file text will take a decade or so. The .lob files are utf-8 plain text files.
I'd like to load the text files into the individual records as I insert all the data, but I'm not sure how to do it. The file I have to load it into MySQL has the following lines (shortened to essentials only):
...
,HISTORY
,@var1
,ACTIVE_FLG
,TRANS_UID
,TRANS_UPDATE
)
SET CONTENT_XML=LOAD_FILE(concat('c:\\files\\',@var1))
I just don't know how to do it for MS SQL Server. Any help or links to webpages that will help me write this INSERT statement are extremely appreciated!
|
|
|
|
|
I figured it out in Excel using the following code on a macro:
Sub Button1_Click()
Dim TextFile As Integer
Dim FilePath As String
Dim FileContent As String
Dim i As Long
For i = 2 To 151807
FilePath = "C:\pubinfo\" & Cells(i, 8).Value
TextFile = FreeFile
Open FilePath For Input As TextFile
FileContent = Input(LOF(TextFile), TextFile)
Close TextFile
FileContent = Right(FileContent, Len(FileContent) - 74)
FileContent = Left(FileContent, Len(FileContent) - 15)
Cells(i, 9).Value = FileContent
Next i
End Sub
It took about two hours to pull in all the text, by the way!
|
|
|
|
|
Just noting....
"lob", from the file name suggests binary data.
In general, programming languages differentiate between binary and text data.
Your code used a "String" type.
That works under one or both of the following conditions.
1. The files wear in fact text
2. Excel did not attempt to translate them.
You can validate the above by exporting at least one file and verifying that it matches the input both in length and content.
|
|
|
|
|
Hi,
I am using MySQL.
Can someone tell me how to write the sql query for retrieving all the last inserted Ids (plural) ?
I have a table in which a column has been inserted by serveral rows everytime depending on how many subject the users tick in the checkboxes.
Now, I have to get all the auto-incremental Ids from all the Ids that have just been inserted.
Is there a way to do it via sql query ?
|
|
|
|
|
|
Hi Richard,
I won't be able to know because each time the subject_Ids varies, it is dependent on the user's no of checkboxes that have been ticked.
So, how ?
|
|
|
|
|
You will have to use some other logic to find out how many new records have been added. Possibly by finding the highest ID number before you start.
|
|
|
|
|
In MS SQL Server, you'd use the OUTPUT clause. Unfortunately, there doesn't seem to be an equivalent for MySQL.
Selecting the top N rows won't work - another user might have inserted rows between your INSERT and SELECT statements. That's why the LAST_INSERT_ID function exists.
MySQL :: MySQL 5.7 Reference Manual :: 27.8.15.3 How to Get the Unique ID for the Last Inserted Row[^]
I suspect you might need to insert the values one at a time, and use LAST_INSERT_ID to retrieve the ID.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
But, how do I insert one at a time when my situation requires me to insert by batch ?
|
|
|
|
|
You can add a timestamp or guid column to mark them. Essentially, you need to have your own logic.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
It's been a while since I've used Access.
I have an Access database with three tables summarized as follows.
Table1
- ID (Primary Key)
- Title (Text)
Table2
- ID (Primary Key)
- Type (Table1.ID combobox lookup single select)
- Other_Fields
Table3
- ID (Primary Key)
- Type (Table1.ID combobox lookup single select)
- Data (Table2.Type combobox multiselect using a query)
- Other_Other_Fields
Without using a form, I would like the Data combobox in Table3 to display only the rows in Table2 where Table2.Type = Table3.Type (=Table1.ID). An inner join is what I'm using, but it's joined to Table1.
SELECT Table2.ID, Table2.Type, Table2.Other_Fields
FROM Table2 INNER JOIN Table1 ON Table2.Type = Table1.ID
WHERE (Table2.Type=Table3.Type);
Here's the problem, according to most of the examples that I've 'oogled, this is done by using a form and requerying the data upon combo update. However, I'm trying to implement this in the table.
The problem that I'm seeing is that when I click on any of the Data fields in Table3, it uses the Type ID of the very first row in Table3. If I change that value of the first row's Type field, the table gets repopulated using this new value for all rows. However, if I click on the Home | Records | Refresh menu (not Refresh All), the row that is selected stays selected and the combobox gets populated with the correct data using that row's Type ID.
So my question is, is there a workaround for this without using a form or am I banging my head against a wall? Is this a "by-design feature" (aka bug)?
Thanks!
|
|
|
|
|
Hi All,
I have three Tables, TableA, TableB and TableC, TableA is loaded from a huge Flat file, TableB is Temp Table or Table Variable, TableC is the Table which is in Production.
I want to load only those records into TableB which are not existing in TableC, I have to check all the columns of the TableC for loading into TableB, means if there are duplicate rows coming from TableA (or from Flat file which already exists in TableC) then those shouldn't be loaded into TableB, we need to check the duplication for all the Columns in every row.
Any advice will be greatly helpful, thanks in advance.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
What have you tried or what ideas do you have?
One way would be to use a left outer join on all the fields and records that are null will need inserting.
Never underestimate the power of human stupidity
RAH
|
|
|
|