Search results

Is there any way to import a bak file to access DB without any application like SQL Server or SQL Server management studio Thank you so much in advance

(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y) Done Tested with another file and work correctly 👌

I'm training on importing files to access DB Learning with a basic JSON file form this site https://www.appsloveworld.com/download-sample-json-file-with-multiple-records

Thanks for your efforts I don't know how to solve type mismatch I think converting JSON is not easy

Can you check attached db and very simple JSON file here is a very simple file but an error appears

@arnelgp @arnelgp can you please give a solution to import JSON also? I tried but did not succeed attached sample file of what I want to import thank you so much for the great help appreciated https://www.access-programmers.co.uk/forums/threads/import-json.328870/

(y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y) (y)...

is there any way to automate importing XML for beginner user I want to use the VBA Code Because I want to hide the ribbon External data > import and link > XML

this file has not been imported please use Form 2 I don't want to duplicate the same row thank you in advance

thanks (y)

Hello thank you for your efforts I don't need code I need the structure of the table I want to map this code to access table for example first name data type text 255 the problem is with address and phone number I don't know how to convert them to fields because they are complex fields...

{ "firstName": "Rack", "lastName": "Jackon", "gender": "man", "age": 24, "address": { "streetAddress": "126", "city": "San Jone", "state": "CA", "postalCode": "394221" }, "phoneNumbers": [ { "type": "home", "number"...

another question: Why was the row repeated 3 times

magic (y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)

Why this code not work I do all the steps Add reference and module attache all code and reference the db with code json file

I need to import this file to table1 in the field field1 the file is not a normal file consisting of rows and columns or you can Import the file to a new table with a single field (All file in one single field) then I can deal with the new table

Hello friends How can I Import along text file (Text Document (.txt)) to an existing field with the primary key = 1

(y) (y) (y) (y) (y) (y) (y) (y) (y) (y)

I try all the way to solve the problem but not work also I compared the result with one date only but still did not get the correct result the application ignores the <= Private Sub txtSearchABBACCT_Change() On Error Resume Next listSearch.Clear If txtSearchABBACCT.value = "" Then FillLIst...

up