Which of the following is NOT true about importing data into a table?
A) The data from an Excel table can be imported into Access table if the Excel table is arranged as a datasheet.
B) When you import data from Excel, it is best practice to insert the table's field names in the spreadsheet's header row.
C) The Import Spreadsheet Wizard can only help import data from Excel if the data is not formatted.
D) The options for importing data into a table are located on the External Data tab.
C
You might also like to view...
Match the example by replacing the ? with the proper function:
I. =???(B7>9,"Bigger","Smaller") II. =???(12%/12,360,-120000) III. =???(A4,B4:F9,2) IV. =???(B9:E21) V. =???() A. NOW B. PMT C. VLOOKUP D. IF E. SUM
When you assign a shortcut key to a macro, it will take precedence over the shortcut keys that are ________
A) used by all applications B) case sensitive C) external to Excel D) built into Excel