python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - ms-access

Importing Excel SpreadSheets Into Access: Unable to Append All Data to the Table

I am importing sheets into my Access table. I have some fields set as Number Fields. The particular column for the Excel sheet is formatted as a Number type. I get the unable to append error. If I cha...
test-img

Ladi Gee

excel

vba

ms-access

Votes: 0

Answers: 1

Latest Answer

Looking at the error message in one of the image you attached, it seems like you are using a primary key from a column in the excel sheet you are importing from. During importation, choose the option ...
test-img

Sola Oshinowo

Syntax Error in Create Table Statement in MS Access but not in phpmyadmin

I need to create an Access database from an existing mySQL database. I was able to import some of the tables using the ODBC connection but a few of the tables were erroring out (saying 'Cannot define...
test-img

xanabobana

sql

ms-access

Votes: 0

Answers: 1

Latest Answer

Access and MySQL SQL dialects don't match well. Furthermore Access DDL comes with details which are unwelcome surprises to many people (see especially Note 2 below). So translating a MySQL CREATE TAB...
test-img

HansUp

Addressing a specific Access Form from Excel VBA

I have an Excel sheet with a command button, which opens an Access form and fills it with data from the sheet. If I have two Access instances running (different databases) I get the message that VBA c...
test-img

aTuring

excel

vba

ms-access

Votes: 0

Answers: 1

Latest Answer

Not sure you need a Form to do this kind of thing. Here's one way to send data from Excel to Access. Sub InsertIntoX2() Dim cn As ADODB.Connection, rs As ADODB.Recordset, row As Long Set cn =...
test-img

ASH

Writing an IIF query in Access

I'm attempting to create an Access db to log company domain names, hosting companies, usernames / passwords etc. I want to create a field with a hyperlink in it which says Iif [software] == 'wordpress...
test-img

TridentMarketingUK

ms-access

Votes: 0

Answers: 1

Latest Answer

In Access, it would be something like this: link = url & IIf([software] = "wordpress", "wpadmin", "admin")
test-img

Gustav

Posts

Questions

Blogs

Jobs