All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

Optimize data import to MS Access 2016 [migrated]

I am having a problem where I attempt to import a file to Access, but the import process bogs down and Access crashes. I am doing this in a desktop environment, and must use a specific desktop for it: ...
0
votes
2answers
108 views

Microsoft access to Sql Server Data Migration [closed]

I need to migrate some old MS Access data to a SQL Server Database. Which tool is easier for a newbie to work with: SQL Server Import/Export or Migration assistant for access(SSMA)
6
votes
2answers
14k views

Import from Access .accdb file to SQL Server [duplicate]

How to import data from Access .accdb file to SQL Server? What should I choose in SQL Server Import and Export Wizard? Suppose we choose OLE DB Provider for SQL Server Integration Services, then if ...
2
votes
3answers
13k views

Easiest way to import access db (.accdb) into SQL Server 2016?

I have a .accfb file from an access 2016 database and am trying to import this database into a SQL Server 2016 developer edition instance. While I found posts online discussing using import/export ...
1
vote
1answer
13 views

Is there a way to input field information by cvs file?

I am importing a new database. I am asked to input field information in MS Access manually. Is there a simpler way? For example, import a cvs version field information into the following
1
vote
1answer
38 views

MS Access fail to recognize correct field width

I am trying to import a very large text file (200 fields +) into MS Access. The text file is not comma separated. I am not sure if it can be called fixed length, since each field has it own length. ...
0
votes
1answer
3k views

MS Access Data Type for time in hh:mm:ss format

My database contains three different sporting events with finishing times imported from an Excel spreadsheet in the hh:mm:ss format. How do I customize the Access data type field to accept this ...
1
vote
0answers
3k views

SQL Server 2014 Import Wizard missing data source option

I have already run the upsizing wizard from my production Access 2010 .accdb database to create all the table structures and move the data on to our new SQL Server 2014. This included adding some PKs ...
1
vote
1answer
66 views

Easiest way of porting data into a database

Recently, I received a lot of information from one of my friends who made a quiz type program. He asked me to help port it into an Access database. His program places all the info in a grid; around ...
0
votes
2answers
920 views

Split date time, with only time, into minutes and seconds

I'm creating an Access database from an excel file that contains metadata about vhs tapes and DVDs. The person who created the excel file had the running times as a date/time field in minutes:seconds. ...
0
votes
1answer
167 views

“key violation” when trying to import data into MS Access [closed]

I am trying to import data into an MS Access table from a flat ASCII file. I've done this many times before but now I am getting a "key violation." There is only one key in the table and it's an ...