Database

2-Jul-17 21:22

how can we connect to ms access 2016 using oledb ..what would be the connection string for that

Richard MacCutchan2-Jul-17 22:03

ConnectionStrings.com - Forgot that connection string? Get it here![^].

2-Jul-17 22:03

Mayank Kumar2-Jul-17 22:25

2-Jul-17 22:25

i went through the ink that u provided but if it comes to connect access 2016 its not working

Mayank Kumar2-Jul-17 22:25

2-Jul-17 22:25

m trying to import excel 2016 file to gridview in vb 2005 and i have installed access database of 2016 while importing m getting the oledb exception called couldn't find install able isam ...in this wazy the problem is only with connection string ,hence what connection string should be used when connecting with acces 2016 in order to import excell 2016 file..i have gone through ur suhhested link but dint work out for access 2016

Richard MacCutchan2-Jul-17 22:35

2-Jul-17 22:35

That is a bit different from your original question. You need to install the ACE driver for oledb. See Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center[^].

Mayank Kumar2-Jul-17 22:41

2-Jul-17 22:41

the link that you provided is not downlowding the driver

Richard MacCutchan2-Jul-17 22:44

2-Jul-17 22:44

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.

jschell5-Jul-17 6:40

5-Jul-17 6:40

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.

Richard MacCutchan5-Jul-17 7:51

5-Jul-17 7:51

Yes it took me a while to figure out the how to do it. But it is Microsoft of course.

Mayank Kumar2-Jul-17 22:46

2-Jul-17 22:46

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

jschell5-Jul-17 6:43

5-Jul-17 6:43

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.

Richard Deeming5-Jul-17 7:54

Richard Deeming

5-Jul-17 7:54

It must be your browser. The checkboxes appear and work fine for me in Firefox 54. Smile | :)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Richard MacCutchan5-Jul-17 21:56

5-Jul-17 21:56

I tried this (and another similar Microsoft page) in both Chrome and Edge, and the checkboxes did not show up in either.

Richard Deeming6-Jul-17 0:58

Richard Deeming

6-Jul-17 0:58

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

Richard MacCutchan6-Jul-17 1:19

6-Jul-17 1:19

Even odder, they now show up for me on both the pages I was trying the other day. I suspect a recent web update.

jschell10-Jul-17 4:18

10-Jul-17 4:18

They now show up for me also.

jschell10-Jul-17 4:16

10-Jul-17 4:16

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.

Trying to replace local file links with actual file contents

Richard Deeming10-Jul-17 4:39

Richard Deeming

10-Jul-17 4:39

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

J Snape2-Jul-17 19:53

J Snape

2-Jul-17 19:53

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      // Where the "C:\files\LAW_SECTION_TBL_1.lob" is stored
  ,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!

Re: Trying to replace local file links with actual file contents

J Snape3-Jul-17 19:51

J Snape

3-Jul-17 19:51

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!

Re: Trying to replace local file links with actual file contents

jschell5-Jul-17 6:51

How do I get all the Ids from my last insert in Mysql?

5-Jul-17 6:51

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.

karengsh27-Jun-17 18:05

karengsh

27-Jun-17 18:05

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 ?

Re: How do I get all the Ids from my last insert in Mysql?

Richard MacCutchan27-Jun-17 19:54