Re: ms access 2016 database - Database Discussion Boards

Re: ms access 2016 database

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

Re: ms access 2016 database

Richard MacCutchan2-Jul-17 22:35

Richard MacCutchan

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[^].

Re: ms access 2016 database

Mayank Kumar2-Jul-17 22:41

Mayank Kumar

2-Jul-17 22:41

the link that you provided is not downlowding the driver

Re: ms access 2016 database

Richard MacCutchan2-Jul-17 22:44

Richard MacCutchan

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.

Re: ms access 2016 database

jschell5-Jul-17 6:40

jschell

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.

Re: ms access 2016 database

Richard MacCutchan5-Jul-17 7:51

Richard MacCutchan

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.

Re: ms access 2016 database

Mayank Kumar2-Jul-17 22:46

Mayank Kumar

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

Re: ms access 2016 database

jschell5-Jul-17 6:43

jschell

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.

Re: ms access 2016 database

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

Re: ms access 2016 database

Richard MacCutchan5-Jul-17 21:56

Richard MacCutchan

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.

Re: ms access 2016 database

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

Re: ms access 2016 database

Richard MacCutchan6-Jul-17 1:19

Richard MacCutchan

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.

Re: ms access 2016 database

jschell10-Jul-17 4:18

jschell

10-Jul-17 4:18

They now show up for me also.

Re: ms access 2016 database

jschell10-Jul-17 4:16

jschell

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.

Re: ms access 2016 database

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

Trying to replace local file links with actual file contents

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

jschell

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.

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

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

Richard MacCutchan

27-Jun-17 19:54

If you know the number of rows that you want: Mysql: Select top N max values? - Stack Overflow[^].

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

karengsh27-Jun-17 21:07

karengsh

27-Jun-17 21:07

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 ?

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

Richard MacCutchan28-Jun-17 8:51

Richard MacCutchan

28-Jun-17 8:51

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.

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

Richard Deeming27-Jun-17 23:51

Richard Deeming

27-Jun-17 23:51

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

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

karengsh28-Jun-17 0:36

karengsh

28-Jun-17 0:36

But, how do I insert one at a time when my situation requires me to insert by batch ?

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

ZurdoDev28-Jun-17 9:48

ZurdoDev

28-Jun-17 9:48

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.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.