Begin by exporting the data from WorkRamp. Depending on WorkRamp's capabilities, navigate to the relevant section of the platform where your data is housed. Look for an export option, typically allowing you to download data as a CSV or Excel file. Ensure you export all necessary fields and data points required for your analysis or storage.

Once you've downloaded the data, open it in a spreadsheet application like Microsoft Excel or Google Sheets. Review the data to ensure it is complete and accurately formatted. Clean the data by removing any unnecessary columns, correcting any obvious errors, and ensuring that all data types are consistent (e.g., dates, numbers).

If not already installed, download and install DuckDB on your system. DuckDB is available for various platforms, including Windows, macOS, and Linux. Visit the official DuckDB website to follow the installation instructions for your operating system.

Launch DuckDB and create a new database file. You can do this by opening a terminal or command prompt and running the command:
```
duckdb mydatabase.duckdb
```
This command initializes a new DuckDB database file named `mydatabase.duckdb`.

With your database ready, you can now load the cleaned and prepared data file into DuckDB. Use DuckDB's built-in SQL functionality to import the data. Start the DuckDB shell by running:
```
duckdb
```
Then, use the following SQL command to read the CSV file into a DuckDB table:
```sql
CREATE TABLE my_table AS SELECT * FROM read_csv_auto('path/to/your/data.csv');
```
Replace `'path/to/your/data.csv'` with the actual file path to your exported CSV file. This command will automatically infer the schema and load the data into a table named `my_table`.

After loading the data, it's crucial to verify that the import was successful. Run a simple SQL query within DuckDB to check the contents of the newly created table:
```sql
SELECT * FROM my_table LIMIT 10;
```
This query will display the first ten rows, allowing you to confirm that the data appears as expected.

Finally, optimize your DuckDB table for performance by creating indexes if necessary. Consider the types of queries you'll be running and create indexes on columns that are frequently used in WHERE clauses. Use the following SQL syntax to create an index:
```sql
CREATE INDEX my_index ON my_table(column_name);
```
Replace `column_name` with the name of the column you want to index. This step will help in speeding up query performance in DuckDB.

By following these steps, you can efficiently transfer data from WorkRamp to DuckDB without relying on third-party tools.