Напускате Airtable? Пренесете базите си в Artavolo, проверени запис по запис. Вижте как

Преминаване от Excel или Access

Обновено

If your business runs on an Excel workbook or an Access database, you can turn the whole file into a base in one go. Each sheet or table becomes a table, a column that names rows of another sheet becomes a link, and formulas stay formulas. Artavolo then checks its answers against the file's own, so you know nothing was lost.

The Excel tab of the Import window after picking Flower shop.xlsx: two tables found, Orders with 5 records (Client as a Link and Total as a Formula) and Clients with 4 records, a note that Orders / Client is linked to Clients, and the Make the base button

Прехвърлете работна книга на Excel

  1. On Home, click Импортирайте електронна таблица, then the Excel tab.
  2. Click Pick or drop the file and choose your workbook. You can pick several files at once.
  3. Check the tables found, each with its records and fields and the type of each field. Untick a table to leave it out. Found in the file lists the links it made, for example that the Client column of Orders now points at the Clients table.
  4. Check the name under The base's name and click Създайте базата.

Take any password off the workbook first.

Прочетете отчета

When the base is made, the window says Вашата база е тук, with the number of records and tables, and then:

  • Formulas and lookups, checked against Excel (or Access): each formula worked out here and compared with the file's own result, record by record. "Matches Excel on all 5 records" means it is right.
  • Made from what the file had: what Artavolo built, such as links.
  • What is different, if anything: things to look at, such as a formula that reaches into other rows (a running total, say). That comes over as its values, never as an error.

The report: Your base is here: Flower shop, 9 records in 2 tables, from Excel. Formulas and lookups, checked against Excel: Orders / Total matches Excel on all 5 records. Made from what the file had: Orders / Client linked to Clients. The buttons Get help finishing it and Open the base

Click Open the base to start using it. Keep the Excel file until your team works in Artavolo; nothing here changes it.

Прехвърлете база данни на Access

  1. Close Access, and make a copy of the .mdb or .accdb file.
  2. On Home, click Импортирайте електронна таблица, then the Access tab.
  3. Click Pick or drop the file and choose the file. If it has a database password, type it under The database's password and click Отворете го.
  4. Check the tables, untick any to leave out, check the base's name and click Създайте базата.

The Access tab of the Import window: every table of the database, Access 97 to 2019, with its relationships as links and its attachments, and the Pick or drop the file area

Чете се Access от 97 до 2019, по една база данни наведнъж. Свързаните таблици са в други файлове: импортирайте и тези файлове.

What comes over from Excel

  • Each sheet as a table. The header row is found even under title rows; merged cells are filled down and a totals row is left out.
  • Field types from the values and number formats: money with its currency symbol, percentages, dates, tick boxes, e-mail addresses, web links, and a status column as a choice list.
  • Формула, повторена надолу по колона, като поле с формула, записана с имена на полета, например {Qty} * {Unit price}.
  • Колона, която посочва редове от друг лист, като връзка, и VLOOKUP през нея като справка.

What comes over from Access

  • Every table, with Access's own types: AutoNumber, Currency, Yes/No, Date/Time, Memo, Hyperlink and rich text.
  • Релациите като връзки: Orders.CustomerID става връзка към записа на клиента. Записите, чийто родител липсва, се броят в отчета.
  • Полета за прикачени файлове с техните файлове.
  • Четимо първо поле, което дава име на всеки запис.
  • The queries, forms, reports, macros and modules, listed by name in the report so you know what to rebuild.

Какво да изградите наново

Need a hand? Get help finishing it, in the report, opens a message to the Artavolo team.

Добре е да знаете

  • Every Excel since 2.0 is read: .xls of every version, .xlsx, .xlsm, .xlsb, the 2003 XML format, OpenDocument (.ods) and CSV.
  • The file is read in your browser; only the base you make is sent.
  • Only owners of a workspace make bases from a file, up to the number of bases on its plan.
  • За да добавите един лист към база, която вече имате, използвайте Импортирай файл като таблица в базата: вижте Импортиране на CSV, Excel или JSON файл.
  • Страници стъпка по стъпка: Преминаване от Excel и Преминаване от Access.

Свързани